View: PAY_ASSIGNMENTS_US_LOV

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ASSIGNMENTS_US_LOV

View Text

SELECT ASS.ROWID
, PER.PERSON_ID
, PER.FULL_NAME
, ASS.ASSIGNMENT_ID
, ASS.ASSIGNMENT_NUMBER
, ASS.EFFECTIVE_START_DATE
, ASS.EFFECTIVE_END_DATE
, ASS.BUSINESS_GROUP_ID + 0
, ASS.PAYROLL_ID
, TUTL.NAME
, TU.ORGANIZATION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL TUTL
, HR_ALL_ORGANIZATION_UNITS TU
, HR_SOFT_CODING_KEYFLEX SCL
, PAY_ALL_PAYROLLS_F PAY
, PER_ALL_ASSIGNMENTS_F ASS
, PER_PEOPLE_F PER
, FND_SESSIONS SES
WHERE TU.ORGANIZATION_ID = TUTL.ORGANIZATION_ID
AND TUTL.LANGUAGE = USERENV('LANG')
AND TU.ORGANIZATION_ID = SCL.SEGMENT1
AND SCL.SOFT_CODING_KEYFLEX_ID = ASS.SOFT_CODING_KEYFLEX_ID
AND ASS.PAYROLL_ID IS NOT NULL
AND SES.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND ASS.PAYROLL_ID = PAY.PAYROLL_ID
AND SES.EFFECTIVE_DATE BETWEEN ASS.EFFECTIVE_START_DATE
AND ASS.EFFECTIVE_END_DATE
AND ASS.PERSON_ID = PER.PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')

Columns