APPS.IGS_AS_VAL_EVSA dependencies on IGS_CA_STAT

Line 60: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

56: gv_other_detail VARCHAR2(255);
57: BEGIN -- assp_val_ci_status
58: -- Validate the ci s_cal_status
59: DECLARE
60: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
61: v_ret_val BOOLEAN DEFAULT TRUE;
62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,
63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
64: SELECT s_cal_status

Line 65: FROM IGS_CA_STAT cs,

61: v_ret_val BOOLEAN DEFAULT TRUE;
62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,
63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
64: SELECT s_cal_status
65: FROM IGS_CA_STAT cs,
66: IGS_CA_INST ci
67: WHERE cs.cal_status = ci.cal_status AND
68: ci.sequence_number = cp_sequence_number AND
69: ci.cal_type = cp_cal_type;