APPS.IGS_ST_VAL_GSLC dependencies on IGS_CA_STAT

Line 17: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';

13: gv_other_detail VARCHAR2(255);
14: BEGIN
15: DECLARE
16: cst_load CONSTANT VARCHAR2(4) := 'LOAD';
17: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
18: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
19: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
20: CURSOR c_ci IS
21: SELECT ct.s_cal_cat,

Line 19: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

15: DECLARE
16: cst_load CONSTANT VARCHAR2(4) := 'LOAD';
17: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
18: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
19: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
20: CURSOR c_ci IS
21: SELECT ct.s_cal_cat,
22: cs.s_cal_status
23: FROM IGS_CA_INST ci,

Line 24: IGS_CA_STAT cs,

20: CURSOR c_ci IS
21: SELECT ct.s_cal_cat,
22: cs.s_cal_status
23: FROM IGS_CA_INST ci,
24: IGS_CA_STAT cs,
25: IGS_CA_TYPE ct
26: WHERE ci.cal_type = p_cal_type AND
27: ci.sequence_number = p_ci_sequence_number AND
28: cs.cal_status = ci.cal_status AND