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 HZ_PARTY_SITE_USES

Line 994: cp_status hz_party_site_uses.status%TYPE,

990: l_get_lic_num c_get_lic_num%ROWTYPE;
991:
992: CURSOR c_get_addr (
993: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
994: cp_status hz_party_site_uses.status%TYPE,
995: cp_site_use_type hz_party_site_uses.site_use_type%TYPE
996: )
997: IS
998: SELECT ps.party_id,

Line 995: cp_site_use_type hz_party_site_uses.site_use_type%TYPE

991:
992: CURSOR c_get_addr (
993: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
994: cp_status hz_party_site_uses.status%TYPE,
995: cp_site_use_type hz_party_site_uses.site_use_type%TYPE
996: )
997: IS
998: SELECT ps.party_id,
999: psu.site_use_type,

Line 1014: hz_party_site_uses psu

1010: l.postal_code,
1011: l.last_update_date
1012: FROM hz_party_sites ps,
1013: hz_locations l,
1014: hz_party_site_uses psu
1015: WHERE ps.location_id = l.location_id
1016: AND ps.party_site_id = psu.party_site_id
1017: AND psu.status = cp_status
1018: AND psu.site_use_type = cp_site_use_type