APPS.IGF_SP_GEN_001 dependencies on HZ_PARTIES

Line 34: p_n_person_id IN hz_parties.party_id%TYPE,

30: p_v_string IN VARCHAR2
31: );
32:
33: PROCEDURE get_sponsor_amts (
34: p_n_person_id IN hz_parties.party_id%TYPE,
35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
37: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
38: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 64: cp_n_person_id IN hz_parties.party_id%TYPE,

60: -------------------------------------------------------------------------------------
61:
62: -- cursor is used if Fee Class parameter has not been passed (Total Sponsor amount case)
63: CURSOR cur_get_all_charges (
64: cp_n_person_id IN hz_parties.party_id%TYPE,
65: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
66: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE
67: ) IS
68: SELECT inv.invoice_id, inv.invoice_amount

Line 77: cp_n_person_id IN hz_parties.party_id%TYPE,

73: AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN');
74:
75: -- cursor is used if course code or unit code and version number parameters are not passed.
76: CURSOR cur_get_charges_no_coursecd (
77: cp_n_person_id IN hz_parties.party_id%TYPE,
78: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
79: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
80: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE
81: ) IS

Line 92: CURSOR cur_get_charges_with_coursecd ( cp_n_person_id IN hz_parties.party_id%TYPE,

88: AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN')
89: AND ft.fee_type = inv.fee_type
90: AND ft.fee_class = cp_v_fee_class;
91:
92: CURSOR cur_get_charges_with_coursecd ( cp_n_person_id IN hz_parties.party_id%TYPE,
93: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
94: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
95: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE

Line 110: cp_n_person_id IN hz_parties.party_id%TYPE,

106: AND ft.fee_type = inv.fee_type
107: AND ft.fee_class = cp_v_fee_class;
108:
109: CURSOR cur_get_charges_for_unit (
110: cp_n_person_id IN hz_parties.party_id%TYPE,
111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,