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

Line 121: --sapanigr 15-Feb-2006 Bug# 5018036 Cursor cur_remit_addr now uses igs_or_inst_org_base_v, hz_party_sites and

117: --Change History:
118: --Who When What
119: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Added cursor cur_usr_profl_name,
120: -- Modified cursor cur_remit_addr
121: --sapanigr 15-Feb-2006 Bug# 5018036 Cursor cur_remit_addr now uses igs_or_inst_org_base_v, hz_party_sites and
122: -- igs_pe_hz_pty_sites igsps instead of igs_or_institution_v orv, igs_pe_addr_v pav
123: --svuppala 04-Oct-2005 Bug# 3813498 Add Fee Class Description To Report To Sponsor From Billing Extract Process
124: -- In PROCEDURE bill_the_person, added new cursor cur_fee_type and added fee_class_meaning
125: -- incase of Sponsor system fee type.

Line 181: hz_party_sites ps,

177: cp_profile_value IN VARCHAR2
178: ) IS
179: SELECT 'Y' found_remit_addr
180: FROM igs_or_inst_org_base_v oi,
181: hz_party_sites ps,
182: igs_pe_hz_pty_sites igsps,
183: igs_pe_partysiteuse_v ppv
184: WHERE ps.party_site_id = cp_n_remit_prty_site_id
185: AND ps.party_site_id = ppv.party_site_id