Sunday, 17 June 2018

How to find the terminated employees in an Organization in Oracle Apps R12


select papf.EMPLOYEE_NUMBER  "Employee Number"
      ,papf.FULL_NAME "Employee Name"
      ,ppsv.LEAVING_REASON "Leaving Reason"
      ,ppsv.ACTUAL_TERMINATION_DATE "Termination Date"
      ,papf.EMAIL_ADDRESS "Email Address"
from per_all_people_f papf
    ,PER_PERIODS_OF_SERVICE_V ppsv
where ppsv.PERSON_ID=papf.PERSON_ID
and papf.EFFECTIVE_END_DATE between papf.EFFECTIVE_START_DATE and SYSDATE
and ppsv.BUSINESS_GROUP_ID=202

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...