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