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_SITES

Line 943: cp_identifying_address_flag hz_party_sites.identifying_address_flag%TYPE

939: l_get_emailaddr c_get_emailaddr%ROWTYPE;
940:
941: CURSOR c_get_paddr (
942: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
943: cp_identifying_address_flag hz_party_sites.identifying_address_flag%TYPE
944: )
945: IS
946: SELECT ps.party_id,
947: ps.identifying_address_flag,

Line 959: FROM hz_party_sites ps,

955: l.county,
956: l.country,
957: l.postal_code,
958: l.last_update_date
959: FROM hz_party_sites ps,
960: hz_locations l ,
961: igs_pe_hz_pty_sites ihps
962: WHERE ps.location_id = l.location_id
963: AND ps.party_site_id = ihps.party_site_id(+)

Line 1012: FROM hz_party_sites ps,

1008: l.county,
1009: l.country,
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