APPS.IGS_FI_VAL_FC dependencies on IGS_FI_FEE_AS_RATE

Line 69: -- which have associated IGS_FI_FEE_AS_RATE records.

65: RETURN BOOLEAN AS
66: gv_other_detail VARCHAR2(255);
67: BEGIN -- finp_chk_rates_exist
68: -- Check if IGS_FI_F_CAT_FEE_LBL records exist for the IGS_FI_FEE_CAT,
69: -- which have associated IGS_FI_FEE_AS_RATE records.
70: DECLARE
71: cst_fcfl CONSTANT VARCHAR2(5) := 'FCFL';
72: CURSOR c_fcfl(
73: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS

Line 85: FROM IGS_FI_FEE_AS_RATE

81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
82: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
83: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
84: SELECT rate_number
85: FROM IGS_FI_FEE_AS_RATE
86: WHERE fee_type= cp_fee_type AND
87: fee_cal_type = cp_fee_cal_type AND
88: fee_ci_sequence_number = cp_fee_ci_sequence_number AND
89: s_relation_type = cst_fcfl AND

Line 115: -- Check if any associated IGS_FI_FEE_AS_RATE records exist for the

111: RETURN FALSE;
112: END IF;
113: -- Use a loop to find any IGS_FI_F_CAT_FEE_LBL records based on the IGS_FI_FEE_CAT.
114: FOR v_fcfl_rec IN c_fcfl(p_fee_cat) LOOP
115: -- Check if any associated IGS_FI_FEE_AS_RATE records exist for the
116: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.
117: OPEN c_far(
118: v_fcfl_rec.fee_type,
119: v_fcfl_rec.fee_cal_type,