APPS.IGS_PR_VAL_SPO dependencies on IGS_CA_TYPE

Line 1118: v_s_cal_type IGS_CA_TYPE.s_cal_cat%TYPE;

1114: BEGIN -- Validate for active and progression calender instance.
1115: DECLARE
1116: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';
1117: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1118: v_s_cal_type IGS_CA_TYPE.s_cal_cat%TYPE;
1119: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
1120: CURSOR c_ci_cat_cs IS
1121: SELECT cat.s_cal_cat,
1122: cs.s_cal_status

Line 1124: IGS_CA_TYPE cat,

1120: CURSOR c_ci_cat_cs IS
1121: SELECT cat.s_cal_cat,
1122: cs.s_cal_status
1123: FROM IGS_CA_INST ci,
1124: IGS_CA_TYPE cat,
1125: IGS_CA_STAT cs
1126: WHERE cat.cal_type = p_cal_type AND
1127: ci.cal_type = cat.cal_type AND
1128: ci.sequence_number = p_ci_sequence_number AND