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

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...