APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_F_CAT_FEE_LBL

Line 187: FUNCTION validate_fcfl(p_c_fee_cat IN igs_fi_f_cat_fee_lbl.fee_cat%TYPE,

183: RETURN l_bool;
184:
185: END validate_ftci;
186:
187: FUNCTION validate_fcfl(p_c_fee_cat IN igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
188: p_c_fee_type IN igs_fi_f_cat_fee_lbl.fee_type%TYPE,
189: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
190:
191: /***********************************************************************************************

Line 188: p_c_fee_type IN igs_fi_f_cat_fee_lbl.fee_type%TYPE,

184:
185: END validate_ftci;
186:
187: FUNCTION validate_fcfl(p_c_fee_cat IN igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
188: p_c_fee_type IN igs_fi_f_cat_fee_lbl.fee_type%TYPE,
189: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
190:
191: /***********************************************************************************************
192:

Line 214: CURSOR cur_fcfl(cp_c_fee_cat igs_fi_f_cat_fee_lbl.fee_cat%TYPE,

210: l_bool BOOLEAN;
211:
212:
213: -- Cursor for validating the Fee Category Fee Liability
214: CURSOR cur_fcfl(cp_c_fee_cat igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
215: cp_c_fee_type igs_fi_f_cat_fee_lbl.fee_type%TYPE,
216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'

Line 215: cp_c_fee_type igs_fi_f_cat_fee_lbl.fee_type%TYPE,

211:
212:
213: -- Cursor for validating the Fee Category Fee Liability
214: CURSOR cur_fcfl(cp_c_fee_cat igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
215: cp_c_fee_type igs_fi_f_cat_fee_lbl.fee_type%TYPE,
216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'
219: FROM igs_fi_f_cat_fee_lbl fcfl,

Line 219: FROM igs_fi_f_cat_fee_lbl fcfl,

215: cp_c_fee_type igs_fi_f_cat_fee_lbl.fee_type%TYPE,
216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'
219: FROM igs_fi_f_cat_fee_lbl fcfl,
220: igs_fi_fee_str_stat fsst
221: WHERE fcfl.fee_cat = cp_c_fee_cat
222: AND fcfl.fee_type = cp_c_fee_type
223: AND fcfl.fee_liability_status = fsst.fee_structure_status