Need to know approval date file & table name of absence records
Summary:
Need to know approval date file & table name of absence records
attached my sql, if anyone please modify and give me the approval date of absence
Content (required):
select per.person_number,
PNAME.DISPLAY_NAME,
abs.absence_type_id "Absence Type Id",
abs.name absence_type,
to_char(apae.start_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') start_date,
to_char(apae.end_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') end_date,
duration "Absence Duration"
, apae.ABSENCE_STATUS_CD
, apae.APPROVAL_STATUS_CD
, apae.PROCESSING_STATUS
, apae.PAYROLL_STATUS
, to_char(apae.SUBMITTED_DATE,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') SUBMITTED_DATE
Tagged:
0