APPS.IGS_FI_LOAD_EXT_CHG dependencies on HZ_PARTIES

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

317: remarks :
318: Change History
319: Who When What
320: sapanigr 24-Feb-2006 Bug#5018036 - Cursor cur_person replaced by call to function igs_fi_gen_008.get_party_number.
321: sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_person now queries hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)
322: svuppala 09-AUG-2005 Enh 3392095 - Tution Waivers build
323: Impact of Charges API version Number change
324: Modified igs_fi_charges_api_pvt.create_charge - version 2.0 and x_waiver_amount
325: gurprsin 26-Jul-2005 Bug# 3392095. Modified table habdler call igs_fi_prc_acct_pkg.build_accounts to include waiver_name column parameter.

Line 431: l_person_number hz_parties.party_number%TYPE;

427:
428: l_n_record_count PLS_INTEGER :=0;
429: l_b_flag BOOLEAN := TRUE;
430:
431: l_person_number hz_parties.party_number%TYPE;
432:
433: CURSOR cur_fee_period(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
434: SELECT igs_ge_date.igschar(start_dt) ||' '|| igs_ge_date.igschar(end_dt) string
435: FROM igs_ca_inst