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 219: PER_PEOPLE_F PER,

215:
216: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS
217: SELECT COUNT(*) cnt
218: FROM GHR_PA_ROUTING_HISTORY PRH,
219: PER_PEOPLE_F PER,
220: PER_ASSIGNMENTS_F ASG,
221: PER_POSITION_EXTRA_INFO PG1
222: WHERE PRH.pa_request_id = p_pa_request_id
223: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')

Line 243: PER_PEOPLE_F PER,

239: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
240: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
241: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
242: FROM GHR_PA_ROUTING_HISTORY PRH,
243: PER_PEOPLE_F PER,
244: PER_ASSIGNMENTS_F ASG,
245: PER_POSITION_EXTRA_INFO PG1
246: WHERE PRH.pa_request_id = p_pa_request_id
247: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')