APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_FEE_TYPE_ALL

Line 62: FROM igs_fi_fee_type_all

58: --Cursor for retreving the Description
59: CURSOR cur_fee_type_desc(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
60: cp_closed_ind igs_fi_fee_type.closed_ind%TYPE) IS
61: SELECT description
62: FROM igs_fi_fee_type_all
63: WHERE fee_type = cp_v_fee_type
64: AND closed_ind = cp_closed_ind;
65:
66: l_rec_chg_header igs_fi_charges_api_pvt.header_rec_type;

Line 109: --Check whether there exists a feetype in the igs_fi_fee_type_all table.

105: cp_closed_ind => 'N');
106: FETCH cur_fee_type_desc INTO l_cur_fee_type_desc;
107:
108:
109: --Check whether there exists a feetype in the igs_fi_fee_type_all table.
110: IF cur_fee_type_desc%NOTFOUND THEN
111: CLOSE cur_fee_type_desc;
112: x_return_status :='E';
113: RETURN;

Line 1239: p_v_fee_type IN igs_fi_fee_type_all.fee_type%TYPE,

1235: p_v_string => 'Returing from the When Others Error Section' );
1236: END update_wav_assign_status;
1237:
1238: FUNCTION check_chg_error_account ( p_n_person_id IN hz_parties.party_id%TYPE,
1239: p_v_fee_type IN igs_fi_fee_type_all.fee_type%TYPE,
1240: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1241: p_n_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE
1242: ) RETURN NUMBER AS
1243: ------------------------------------------------------------------