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.

APPS.PSP_PSPENCSC_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 146: PER_ALL_PEOPLE_F PAF1

142: SELECT
143: PAF1.EMPLOYEE_NUMBER
144: INTO V_EMPLOYEE_NUMBER
145: FROM
146: PER_ALL_PEOPLE_F PAF1
147: WHERE PERSON_ID = PERSON_ID1
148: AND EFFECTIVE_START_DATE = (
149: SELECT
150: MIN(EFFECTIVE_START_DATE)

Line 152: PER_ALL_PEOPLE_F PAF2

148: AND EFFECTIVE_START_DATE = (
149: SELECT
150: MIN(EFFECTIVE_START_DATE)
151: FROM
152: PER_ALL_PEOPLE_F PAF2
153: WHERE PAF1.PERSON_ID = PAF2.PERSON_ID
154: AND PAF2.CURRENT_EMPLOYEE_FLAG = 'Y' );
155: RETURN (V_EMPLOYEE_NUMBER);
156: EXCEPTION