APPS.IGS_FI_VAL_FCCI dependencies on IGS_CA_INST

Line 41: cp_cal_type IGS_CA_INST.cal_type%TYPE,

37: FROM IGS_FI_FEE_STR_STAT fss
38: WHERE fss.fee_structure_status = cp_fee_cat_ci_status AND
39: fss.s_fee_structure_status = cst_active;
40: CURSOR c_cict (
41: cp_cal_type IGS_CA_INST.cal_type%TYPE,
42: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
43: SELECT cat.s_cal_cat,
44: cs.s_cal_status
45: FROM IGS_CA_INST ci,

Line 42: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

38: WHERE fss.fee_structure_status = cp_fee_cat_ci_status AND
39: fss.s_fee_structure_status = cst_active;
40: CURSOR c_cict (
41: cp_cal_type IGS_CA_INST.cal_type%TYPE,
42: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
43: SELECT cat.s_cal_cat,
44: cs.s_cal_status
45: FROM IGS_CA_INST ci,
46: IGS_CA_STAT cs,

Line 45: FROM IGS_CA_INST ci,

41: cp_cal_type IGS_CA_INST.cal_type%TYPE,
42: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
43: SELECT cat.s_cal_cat,
44: cs.s_cal_status
45: FROM IGS_CA_INST ci,
46: IGS_CA_STAT cs,
47: IGS_CA_TYPE cat
48: WHERE ci.cal_type = cp_cal_type AND
49: ci.sequence_number = cp_sequence_number AND

Line 408: FROM IGS_CA_INST ci,

404: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
405: CURSOR c_ci_cat_cs IS
406: SELECT cat.s_cal_cat,
407: cs.s_cal_status
408: FROM IGS_CA_INST ci,
409: IGS_CA_TYPE cat,
410: IGS_CA_STAT cs
411: WHERE ci.cal_type = p_fee_cal_type AND
412: ci.sequence_number = p_fee_ci_sequence_number AND