VIEW: APPS.PAY_AU_TERM_EMP_ASG_V

Source

View Text - Preformatted

SELECT ass.assignment_id , ass.assignment_number , per.person_id , per.employee_number , serv.period_of_service_id , ass.business_group_id , per.full_name , per.date_of_birth , per.original_date_of_hire , ass.payroll_id , serv.date_start , serv.actual_termination_date , hr1.meaning from per_periods_of_service_v serv , per_people_v per , per_assignments_f ass , fnd_sessions sesh , per_business_groups bus , hr_lookups hr1 WHERE ass.person_id = per.person_id and per.person_id = serv.person_id and userenv ('sessionid') = sesh.session_id and ass.business_group_id = bus.business_group_id and per.business_group_id = bus.business_group_id and serv.business_group_id = bus.business_group_id and bus.legislation_code = 'AU' and hr1.lookup_type (+) = 'AU_TERMINATION_TYPE' and hr1.lookup_code (+) = serv.pds_information1 and hr1.enabled_flag (+) = 'Y' and sesh.effective_date between ass.effective_start_date and ass.effective_end_date and sesh.effective_date between per.effective_start_date and per.effective_end_date and ass.period_of_service_id=serv.period_of_service_id

View Text - HTML Formatted

SELECT ASS.ASSIGNMENT_ID
, ASS.ASSIGNMENT_NUMBER
, PER.PERSON_ID
, PER.EMPLOYEE_NUMBER
, SERV.PERIOD_OF_SERVICE_ID
, ASS.BUSINESS_GROUP_ID
, PER.FULL_NAME
, PER.DATE_OF_BIRTH
, PER.ORIGINAL_DATE_OF_HIRE
, ASS.PAYROLL_ID
, SERV.DATE_START
, SERV.ACTUAL_TERMINATION_DATE
, HR1.MEANING
FROM PER_PERIODS_OF_SERVICE_V SERV
, PER_PEOPLE_V PER
, PER_ASSIGNMENTS_F ASS
, FND_SESSIONS SESH
, PER_BUSINESS_GROUPS BUS
, HR_LOOKUPS HR1
WHERE ASS.PERSON_ID = PER.PERSON_ID
AND PER.PERSON_ID = SERV.PERSON_ID
AND USERENV ('SESSIONID') = SESH.SESSION_ID
AND ASS.BUSINESS_GROUP_ID = BUS.BUSINESS_GROUP_ID
AND PER.BUSINESS_GROUP_ID = BUS.BUSINESS_GROUP_ID
AND SERV.BUSINESS_GROUP_ID = BUS.BUSINESS_GROUP_ID
AND BUS.LEGISLATION_CODE = 'AU'
AND HR1.LOOKUP_TYPE (+) = 'AU_TERMINATION_TYPE'
AND HR1.LOOKUP_CODE (+) = SERV.PDS_INFORMATION1
AND HR1.ENABLED_FLAG (+) = 'Y'
AND SESH.EFFECTIVE_DATE BETWEEN ASS.EFFECTIVE_START_DATE
AND ASS.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND ASS.PERIOD_OF_SERVICE_ID=SERV.PERIOD_OF_SERVICE_ID