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 288: from GHR_PA_REQUESTS gpr

284: -- the positions which are already assigned will be
285: -- core validation on PER_ALL_ASSIGNMENTS
286: cursor c_par_exists is
287: select gpr.pa_request_id
288: from GHR_PA_REQUESTS gpr
289: where gpr.to_position_id = p_position_id
290: and pa_notification_id is null
291: and status <> 'CANCELED';
292:

Line 385: from GHR_PA_REQUESTS gpr

381: l_chk number;
382:
383: cursor c_par_exists is
384: select gpr.pa_request_id
385: from GHR_PA_REQUESTS gpr
386: where gpr.person_id = p_person_id;
387:
388: begin
389:

Line 544: ,ghr_pa_requests par

540: ', SSN:'||per.national_identifier||
541: ', Updater:'||prh.user_name list_info
542: FROM per_people_f per
543: ,ghr_pa_routing_history prh
544: ,ghr_pa_requests par
545: WHERE par.to_position_id = p_position_id
546: AND par.effective_date >= p_effective_date
547: AND prh.pa_request_id = par.pa_request_id
548: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)