View: PAY_AU_TERM_EMP_ASG_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_TERM_EMP_ASG_V

View Text

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

Columns