APPS.IGS_FI_GEN_008 dependencies on HZ_PARTIES

Line 179: FROM hz_parties

175: Who When What
176: ***********************************************************************************************/
177: CURSOR cur_party_number(cp_n_party_id NUMBER) IS
178: SELECT party_number
179: FROM hz_parties
180: WHERE party_id = cp_n_party_id;
181: l_v_party_number hz_parties.party_number%TYPE;
182:
183: BEGIN

Line 181: l_v_party_number hz_parties.party_number%TYPE;

177: CURSOR cur_party_number(cp_n_party_id NUMBER) IS
178: SELECT party_number
179: FROM hz_parties
180: WHERE party_id = cp_n_party_id;
181: l_v_party_number hz_parties.party_number%TYPE;
182:
183: BEGIN
184:
185: IF p_n_party_id IS NULL THEN

Line 235: PROCEDURE chk_chg_adj( p_n_person_id IN hz_parties.party_id%TYPE,

231: END get_invoice_number;
232:
233:
234:
235: PROCEDURE chk_chg_adj( p_n_person_id IN hz_parties.party_id%TYPE,
236: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
237: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
238: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
239: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,

Line 267: cp_person_id hz_parties.party_id%TYPE,

263: AND (inv.optional_fee_flag = g_v_opt_fee_decl OR inv.waiver_flag = g_v_waiver_yes);
264:
265: --cursor to check whether a particular charge has been reversed or declined
266: CURSOR cur_chk_rev_decl_no_inv_id(
267: cp_person_id hz_parties.party_id%TYPE,
268: cp_location_cd igs_fi_fee_as_items.location_cd%TYPE,
269: cp_course_cd igs_ps_ver.course_cd%TYPE,
270: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
271: cp_fee_cat igs_fi_fee_as_items.fee_cat%TYPE,