APPS.IGS_FI_VAL_FCFL dependencies on IGS_CA_INST

Line 34: cp_cal_type IGS_CA_INST.cal_type%TYPE,

30: FROM IGS_FI_FEE_STR_STAT fss
31: WHERE fss.fee_structure_status = cp_fee_liability_status AND
32: fss.s_fee_structure_status = cst_active;
33: CURSOR c_cict (
34: cp_cal_type IGS_CA_INST.cal_type%TYPE,
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,

Line 35: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

31: WHERE fss.fee_structure_status = cp_fee_liability_status AND
32: fss.s_fee_structure_status = cst_active;
33: CURSOR c_cict (
34: cp_cal_type IGS_CA_INST.cal_type%TYPE,
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,

Line 38: FROM IGS_CA_INST ci,

34: cp_cal_type IGS_CA_INST.cal_type%TYPE,
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

Line 278: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

274: --
275: -- Validate insert of FCFL does not clash currency with FTCI definitions
276: FUNCTION finp_val_fcfl_cur(
277: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
278: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
279: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
280: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
281: p_message_name OUT NOCOPY VARCHAR2 )
282: RETURN BOOLEAN AS