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.IGS_CO_PROCESS dependencies on IGS_PE_PERS_ENCUMB

Line 812: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef

808: l_cur_get_sub cur_get_sub%ROWTYPE;
809:
810: CURSOR check_hold_exists IS
811: SELECT COUNT ('x')
812: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef
813: WHERE ppe.person_id = p_person_id
814: AND ppe.person_id = ppef.person_id
815: AND ppe.encumbrance_type = ppef.encumbrance_type
816: AND ppe.start_dt = ppef.pen_start_dt

Line 828: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef,igs_pe_person_base_v ppbv,igs_fi_encmb_type fet

824: l_hold_count NUMBER;
825:
826: CURSOR log_details IS
827: SELECT ppbv.full_name,ppbv.person_number,fet.description
828: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef,igs_pe_person_base_v ppbv,igs_fi_encmb_type fet
829: WHERE ppe.person_id = p_person_id
830: AND ppe.person_id = ppef.person_id
831: AND ppe.person_id = ppbv.person_id
832: AND ppe.encumbrance_type = ppef.encumbrance_type