Element Entry - AsgDS

 /* Associate Record */
SELECT PAAM.ASSIGNMENT_ID
, PAAM.REASON_CODE
, PAPF.PERSON_ID
, PAPF.PERSON_NUMBER PER_NUM
, PPNF.FIRST_NAME FNAME
, PPNF.LAST_NAME LNAME
, PPNF.MIDDLE_NAMES MNAME
, PP.DATE_OF_BIRTH DOB
, PPOS.DATE_START
, PAST.USER_STATUS
, XLE.LEGAL_ENTITY_IDENTIFIER COMPANY
FROM PER_PERIODS_OF_SERVICE PPOS
, PER_ALL_ASSIGNMENTS_M PAAM
, PER_ALL_PEOPLE_F PAPF
, PER_PERSON_NAMES_F PPNF
, PER_PERSONS PP
, PER_ASSIGNMENT_STATUS_TYPES_TL PAST
, HR_ALL_ORGANIZATION_UNITS_F_VL HAOU_LE
, XLE_ENTITY_PROFILES XLE
WHERE 1=1
AND PAAM.PERIOD_OF_SERVICE_ID = PPOS.PERIOD_OF_SERVICE_ID
AND PAAM.PERSON_ID = PAPF.PERSON_ID
AND PAAM.PRIMARY_FLAG = 'Y'
AND PAAM.ASSIGNMENT_TYPE = 'E'
AND PAAM.EFFECTIVE_LATEST_CHANGE = 'Y'
AND :AsOfDate BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PPOS.PERSON_ID
AND :AsOfDate BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND PPNF.PERSON_ID = PAPF.PERSON_ID
AND PPNF.NAME_TYPE = 'GLOBAL'
AND :AsOfDate BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
AND PP.PERSON_ID = PAPF.PERSON_ID
AND PAST.ASSIGNMENT_STATUS_TYPE_ID = PAAM.ASSIGNMENT_STATUS_TYPE_ID
AND PAST.LANGUAGE = 'US'
AND HAOU_LE.ORGANIZATION_ID = PAAM.LEGAL_ENTITY_ID
AND :AsOfDate BETWEEN HAOU_LE.EFFECTIVE_START_DATE AND HAOU_LE.EFFECTIVE_END_DATE
AND XLE.LEGAL_ENTITY_ID = HAOU_LE.LEGAL_ENTITY_ID