APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_PE_ADDR_V

Line 122: -- igs_pe_hz_pty_sites igsps instead of igs_or_institution_v orv, igs_pe_addr_v pav

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.
126: --pathipat 21-Jul-2004 Bug 3778782 - Modified the way bill_the_person is invoked

Line 487: FROM igs_pe_addr_v pav,

483: pav.county,
484: pav.country,
485: pav.postal_code,
486: pav.delivery_point_code
487: FROM igs_pe_addr_v pav,
488: igs_pe_partysiteuse_v ppv
489: WHERE pav.person_id = p_n_person_id
490: AND pav.party_site_id = ppv.party_site_id
491: AND ppv.site_use_type IN (cp_c_site_usg_type_cd_1,cp_c_site_usg_type_cd_2,cp_c_site_usg_type_cd_3)

Line 514: FROM igs_pe_addr_v

510: county,
511: country,
512: postal_code,
513: delivery_point_code
514: FROM igs_pe_addr_v
515: WHERE party_site_id = cp_n_remit_prty_site_id;
516:
517: -- Bug#2564643 Modified cursor defination of cur_opening_balance
518: -- Removed the parameter subaccount_id to cursor and usage of column