APPS.IGS_AD_VAL_APAC dependencies on IGS_CA_STAT

Line 350: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

346: DECLARE
347: cst_admission CONSTANT VARCHAR2(9) := 'ADMISSION';
348: cst_active CONSTANT VARCHAR2(9) := 'ACTIVE'; --removed the planned variable (cst_planned) as per bug#2722785 --rghosh
349: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
350: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
352: v_start_dt IGS_CA_INST.start_dt%TYPE;
353: v_end_dt IGS_CA_INST.end_dt%TYPE;
354: CURSOR c_s_cal_cat (

Line 368: IGS_CA_STAT cs

364: ci.alternate_code,
365: ci.start_dt,
366: ci.end_dt
367: FROM IGS_CA_INST ci,
368: IGS_CA_STAT cs
369: WHERE ci.cal_type = cp_adm_cal_type AND
370: ci.sequence_number = cp_adm_ci_sequence_number AND
371: ci.cal_status = cs.cal_status;
372: