eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_ASSIGNMENTS_US_LOV

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')