APPS.IGS_FI_VAL_FLS dependencies on IGS_FI_FEE_STR_STAT

Line 22: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;

18: -- Validate if the IGS_FI_FEE_LBL_SPNSR is related to a
19: -- IGS_FI_F_CAT_FEE_LBL which is ACTIVE.
20: DECLARE
21: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
22: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
23: CURSOR c_fss IS
24: SELECT s_fee_structure_status
25: FROM IGS_FI_FEE_STR_STAT fss,
26: IGS_FI_F_CAT_FEE_LBL fcfl

Line 25: FROM IGS_FI_FEE_STR_STAT fss,

21: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
22: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
23: CURSOR c_fss IS
24: SELECT s_fee_structure_status
25: FROM IGS_FI_FEE_STR_STAT fss,
26: IGS_FI_F_CAT_FEE_LBL fcfl
27: WHERE fcfl.fee_cat = p_fee_cat AND
28: fcfl.fee_cal_type = p_fee_cal_type AND
29: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND