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 IGS_PE_HZ_PTY_SITES

Line 883: start date and end date from igs_pe_hz_pty_sites.

879: Change History
880: Who When What
881: gmaheswa 24-Nov-2003 Bug : 3227107 Address active check changes
882: Modified c_get_paddr cursor to select active records only and to select
883: start date and end date from igs_pe_hz_pty_sites.
884: (reverse chronological order - newest change first)
885: **************************************************************/
886: CURSOR c_get_ssn (
887: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

Line 961: igs_pe_hz_pty_sites ihps

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(+)
964: AND ps.identifying_address_flag = cp_identifying_address_flag
965: AND ( ps.status = 'A' AND SYSDATE BETWEEN NVL(ihps.start_date,SYSDATE)