APPS.IGS_ST_VAL_GSLC dependencies on IGS_CA_TYPE

Line 18: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

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,
22: cs.s_cal_status

Line 25: IGS_CA_TYPE ct

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
29: ct.cal_type = ci.cal_type;