APPS.IGS_FI_BILL_EXTRACT dependencies on HZ_PARTIES

Line 258: --sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_person_number now queries hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)

254: --abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
255: --sapanigr 24-Feb-2006 Bug#5018036 - Cursor cur_person_number removed and replaced by call to function igs_fi_gen_008.get_party_number.
256: --sapanigr 15-Feb-2006 Bug#5018036 - Cursor cur_bill_to_addr was a union of three select stmts. This is
257: -- changed to one select statement by using IN function to reduce share memory usage.
258: --sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_person_number now queries hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)
259: --sapanigr 23-Nov-2005 Bug#4744481 - Cursor cur_bill_to_addr modifed to check for active address usage.
260: --sapanigr 26-Oct-2005 Bug#4686200 - Modified the Cursor cur_bill_to_addr to check for active address.
261: --svuppala 04-Oct-2005 Bug# 3813498 Add Fee Class Description To Report To Sponsor From Billing Extract Process
262: -- Added new cursor cur_fee_type and added fee_class_meaning

Line 596: l_person_number hz_parties.party_number%TYPE;

592: l_r_bill_trans_row_id VARCHAR2(25);
593: l_r_bill_addr_row_id VARCHAR2(25);
594: l_n_transaction_id NUMBER;
595: l_n_bill_addr_id NUMBER;
596: l_person_number hz_parties.party_number%TYPE;
597: rec_cur_charges_total cur_charges_total%ROWTYPE;
598: rec_cur_credits_total cur_credits_total%ROWTYPE;
599: rec_cur_bill_to_addr cur_bill_to_addr%ROWTYPE;
600: rec_cur_remitt_addr cur_remitt_addr%ROWTYPE;