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_AD_GEN_011 dependencies on IGS_PE_ADDR_V

Line 1137: igs_pe_addr_v padv,

1133: FROM igs_ad_appl aa,
1134: igs_ad_appl_ltr aal,
1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1136: igs_ps_ver pv,
1137: igs_pe_addr_v padv,
1138: igs_pe_res_dtls_v prdv
1139: WHERE aa.acad_cal_type LIKE cp_acad_cal_type
1140: AND aa.acad_ci_sequence_number LIKE cp_acad_ci_sequence_number
1141: AND NVL(acaiv.adm_cal_type, aa.adm_cal_type) LIKE cp_adm_cal_type

Line 1183: igs_pe_addr_v padv

1179: aal.sequence_number,
1180: aal.spl_sequence_number
1181: FROM igs_ad_appl aa,
1182: igs_ad_appl_ltr aal,
1183: igs_pe_addr_v padv
1184: WHERE aa.person_id = aal.person_id
1185: AND aa.person_id = padv.person_id (+)
1186: AND aal.person_id = cp_person_id
1187: AND aal.correspondence_type = cp_correspondence_type;

Line 1268: igs_pe_addr_v padv

1264: aal.sequence_number sequence_number,
1265: aal.spl_sequence_number spl_sequence_number, padv.' || p_sortby ||
1266: ' FROM igs_ad_appl aa,
1267: igs_ad_appl_ltr aal,
1268: igs_pe_addr_v padv
1269: WHERE aa.person_id = aal.person_id
1270: AND aa.person_id = padv.person_id (+)
1271: AND aal.person_id = :1
1272: AND aal.correspondence_type = :2

Line 1326: igs_pe_addr_v padv,

1322: FROM igs_ad_appl aa,
1323: igs_ad_appl_ltr aal,
1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1325: igs_ps_ver pv,
1326: igs_pe_addr_v padv,
1327: igs_pe_res_dtls_v prdv
1328: WHERE aa.acad_cal_type LIKE :1
1329: AND aa.acad_ci_sequence_number LIKE :2
1330: AND NVL(acaiv.adm_cal_type, aa.adm_cal_type) LIKE :3