APPS.IGS_EN_VAL_SCA dependencies on IGS_CA_STAT

Line 1498: IGS_CA_STAT CS

1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,
1496: IGS_CA_INST CI,
1497: IGS_CA_TYPE CT,
1498: IGS_CA_STAT CS
1499: WHERE CT.closed_ind = 'N' AND
1500: CT.s_cal_cat = cst_load AND
1501: CS.s_cal_status = cst_active AND
1502: CI.cal_status = CS.cal_status AND

Line 2597: v_cs_scs IGS_CA_STAT.s_cal_status%TYPE;

2593: DECLARE
2594: v_other_detail VARCHAR2(255);
2595: v_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
2596: v_ci_rec IGS_CA_INST%ROWTYPE;
2597: v_cs_scs IGS_CA_STAT.s_cal_status%TYPE;
2598: cst_active CONSTANT VARCHAR2(8):= 'ACTIVE';
2599: CURSOR c_cop_rec IS
2600: SELECT *
2601: FROM IGS_PS_OFR_PAT

Line 2616: FROM IGS_CA_STAT,

2612: WHERE cal_type = p_cal_type AND
2613: sequence_number = p_ci_sequence_number;
2614: CURSOR c_cs_scs IS
2615: SELECT s_cal_status
2616: FROM IGS_CA_STAT,
2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN

Line 2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;

2614: CURSOR c_cs_scs IS
2615: SELECT s_cal_status
2616: FROM IGS_CA_STAT,
2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.

Line 2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;

2615: SELECT s_cal_status
2616: FROM IGS_CA_STAT,
2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.
2623: -- checking if the IGS_PS_OFR_PAT