APPS.IGS_FI_VAL_FCFL dependencies on IGS_CA_STAT

Line 25: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

21: DECLARE
22: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
23: cst_fee CONSTANT VARCHAR2(3) := 'FEE';
24: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
25: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
26: v_dummy VARCHAR2(1);
27: CURSOR c_fss (
28: cp_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE) IS
29: SELECT 'x'

Line 39: IGS_CA_STAT cs,

35: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
36: SELECT cat.s_cal_cat,
37: cs.s_cal_status
38: FROM IGS_CA_INST ci,
39: IGS_CA_STAT cs,
40: IGS_CA_TYPE cat
41: WHERE ci.cal_type = cp_cal_type AND
42: ci.sequence_number = cp_sequence_number AND
43: ci.cal_type = cat.cal_type AND