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.IGF_SL_PREF_LENDER dependencies on IGS_PE_PERSID_GROUP_ALL

Line 286: cp_perid_grp igs_pe_persid_group_all.group_id%TYPE,

282:
283: l_get_relation_code c_get_relation_code%ROWTYPE;
284:
285: CURSOR c_chk_perid_grp (
286: cp_perid_grp igs_pe_persid_group_all.group_id%TYPE,
287: cp_closed_ind igs_pe_persid_group_all.closed_ind%TYPE
288: )
289: IS
290: SELECT group_cd

Line 287: cp_closed_ind igs_pe_persid_group_all.closed_ind%TYPE

283: l_get_relation_code c_get_relation_code%ROWTYPE;
284:
285: CURSOR c_chk_perid_grp (
286: cp_perid_grp igs_pe_persid_group_all.group_id%TYPE,
287: cp_closed_ind igs_pe_persid_group_all.closed_ind%TYPE
288: )
289: IS
290: SELECT group_cd
291: FROM igs_pe_persid_group_all

Line 291: FROM igs_pe_persid_group_all

287: cp_closed_ind igs_pe_persid_group_all.closed_ind%TYPE
288: )
289: IS
290: SELECT group_cd
291: FROM igs_pe_persid_group_all
292: WHERE group_id = cp_perid_grp
293: AND closed_ind = cp_closed_ind
294: AND create_dt <= SYSDATE;
295: