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_IMP_008 dependencies on IGS_PE_HZ_PARTIES

Line 2431: FROM igs_pe_hz_parties pzp, hz_parties hp, Igs_Or_Inst_Stat stat

2427: -- Validate the INSTITUTION_CD.
2428: CURSOR Institution_C(cp_Institution_Cd Igs_Ad_Relacad_Int.Institution_Code%TYPE,
2429: cp_inst_status Igs_Or_Inst_Stat.S_Institution_Status%TYPE) IS
2430: SELECT 1
2431: FROM igs_pe_hz_parties pzp, hz_parties hp, Igs_Or_Inst_Stat stat
2432: WHERE pzp.party_id = hp.party_id AND
2433: hp.party_number = cp_institution_cd AND
2434: pzp.OI_INSTITUTION_STATUS = stat.Institution_Status AND
2435: pzp.inst_org_ind = 'I' AND