APPS.IGS_CA_VAL_CAT dependencies on IGS_CA_STAT

Line 16: IGS_CA_STAT cs

12: CURSOR c_cal_instance_rec (
13: cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS
14: SELECT DISTINCT 'x'
15: FROM IGS_CA_INST ci,
16: IGS_CA_STAT cs
17: WHERE ci.CAL_TYPE = cp_cal_type AND
18: cs.CAL_STATUS = ci.CAL_STATUS AND
19: cs.s_cal_status IN (cst_active, cst_inactive);
20: v_other_detail VARCHAR2(255);