You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to know approval date file & table name of absence records

Accepted answer
42
Views
2
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!