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_GEN dependencies on IGS_PE_EIT_PERM_RES_V

Line 1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE

1024:
1025:
1026: CURSOR c_get_reg_num (
1027: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE
1029: )
1030: IS
1031: SELECT document_num
1032: FROM igs_pe_eit_perm_res_v

Line 1032: FROM igs_pe_eit_perm_res_v

1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE
1029: )
1030: IS
1031: SELECT document_num
1032: FROM igs_pe_eit_perm_res_v
1033: WHERE perm_res_cntry = cp_perm_res_cntry
1034: AND person_id = cp_person_id
1035: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1036: