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_009 dependencies on HZ_PARTY_SITE_USES

Line 640: FROM hz_party_sites PS,hz_party_site_uses PSU

636:
637: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
638: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
639: SELECT PS.party_site_id
640: FROM hz_party_sites PS,hz_party_site_uses PSU
641: WHERE PS.party_site_id = PSU.party_site_id AND
642: PS.party_id = cp_person_id AND
643: PSU.site_use_type = cp_addr_type;
644:

Line 991: FROM hz_party_sites PS,hz_party_site_uses PSU

987:
988: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
989: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
990: SELECT PS.party_site_id
991: FROM hz_party_sites PS,hz_party_site_uses PSU
992: WHERE PS.party_site_id = PSU.party_site_id AND
993: PS.party_id = cp_person_id AND
994: PSU.site_use_type = cp_addr_type;
995: