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.GHR_GEN_RPA_NPA dependencies on PER_PEOPLE_F

Line 169: PER_PEOPLE_F PER,

165:
166: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS
167: SELECT COUNT(*) cnt
168: FROM GHR_PA_ROUTING_HISTORY PRH,
169: PER_PEOPLE_F PER,
170: PER_ASSIGNMENTS_F ASG,
171: PER_POSITION_EXTRA_INFO PG1
172: WHERE PRH.pa_request_id = p_pa_request_id
173: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')

Line 193: PER_PEOPLE_F PER,

189: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
190: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
191: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
192: FROM GHR_PA_ROUTING_HISTORY PRH,
193: PER_PEOPLE_F PER,
194: PER_ASSIGNMENTS_F ASG,
195: PER_POSITION_EXTRA_INFO PG1
196: WHERE PRH.pa_request_id = p_pa_request_id
197: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')