APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PE_HZ_PARTIES

Line 1877: FROM hz_parties hp, igs_pe_hz_parties ihp

1873: ***********************************************************************************************/
1874:
1875: CURSOR c_inst IS
1876: SELECT 'x'
1877: FROM hz_parties hp, igs_pe_hz_parties ihp
1878: WHERE hp.party_id = ihp.party_id AND
1879: ihp.inst_org_ind = 'I' AND
1880: ihp.oi_govt_institution_cd is not null AND
1881: ihp.oss_org_unit_cd = p_institution_name ;