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_VALIDATE_PERWSDPO dependencies on GHR_PA_REQUESTS

Line 284: from GHR_PA_REQUESTS gpr

280: l_chk number;
281:
282: cursor c_par_exists is
283: select gpr.pa_request_id
284: from GHR_PA_REQUESTS gpr
285: where gpr.to_position_id = p_position_id;
286:
287: begin
288:

Line 316: from GHR_PA_REQUESTS gpr

312: l_chk number;
313:
314: cursor c_par_exists is
315: select gpr.pa_request_id
316: from GHR_PA_REQUESTS gpr
317: where gpr.person_id = p_person_id;
318:
319: begin
320:

Line 475: ,ghr_pa_requests par

471: ', SSN:'||per.national_identifier||
472: ', Updater:'||prh.user_name list_info
473: FROM per_people_f per
474: ,ghr_pa_routing_history prh
475: ,ghr_pa_requests par
476: WHERE par.to_position_id = p_position_id
477: AND par.effective_date >= p_effective_date
478: AND prh.pa_request_id = par.pa_request_id
479: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)