APPS.IGS_FI_VAL_FCCI dependencies on IGS_CA_STAT

Line 32: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

28: DECLARE
29: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
30: cst_fee CONSTANT VARCHAR2(3) := 'FEE';
31: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
32: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
33: v_dummy VARCHAR2(1);
34: CURSOR c_fss (
35: cp_fee_cat_ci_status IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE) IS
36: SELECT 'x'

Line 46: IGS_CA_STAT cs,

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
50: ci.cal_type = cat.cal_type AND

Line 404: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

400: gv_other_detail VARCHAR2(255);
401: BEGIN
402: DECLARE
403: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
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,

Line 410: IGS_CA_STAT cs

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
413: ci.cal_type = cat.CAL_TYPE AND
414: ci.cal_status = cs.CAL_STATUS;