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_FI_PRC_APINT dependencies on HZ_PARTY_SITES

Line 239: || from igs_pe_hz_pty_sites instead of hz_party_sites.

235: || Known limitations, enhancements or remarks :
236: || Change History :
237: || Who When What
238: || gmaheswa 19-nov-2003 Bug 3227107 address changes. Modified cursor c_hz_site to select dates
239: || from igs_pe_hz_pty_sites instead of hz_party_sites.
240: || (reverse chronological order - newest change first)
241: ******************************************************************/
242:
243: -- Cursor for selecting an Active Pay to Usage address for a party

Line 246: FROM hz_party_sites ps,

242:
243: -- Cursor for selecting an Active Pay to Usage address for a party
244: CURSOR c_hz_site(cp_n_party_id hz_parties.party_id%TYPE) IS
245: SELECT ps.location_id
246: FROM hz_party_sites ps,
247: hz_party_site_uses psu,
248: igs_pe_hz_pty_sites ips
249: WHERE ps.party_site_id = ips.party_site_id(+)
250: AND ps.party_id = cp_n_party_id