APPS.IGS_FI_VAL_FCFL dependencies on IGS_CA_TYPE

Line 24: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

20: -- IGS_FI_F_CAT_FEE_LBL status to active.
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

Line 40: IGS_CA_TYPE cat

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
44: ci.cal_status = cs.cal_status;

Line 277: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,

273: END finp_val_fcfl_status;
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 )