APPS.IGS_AS_VAL_UAI dependencies on IGS_CA_STAT

Line 217: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

213: p_ci_sequence_number IN NUMBER ,
214: p_message_name OUT NOCOPY VARCHAR2 )
215: RETURN BOOLEAN IS
216: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
217: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status

Line 221: SELECT IGS_CA_STAT.s_cal_status

217: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

Line 222: FROM IGS_CA_INST, IGS_CA_STAT

218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);

Line 225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);
227: BEGIN
228: P_MESSAGE_NAME := null;
229: OPEN c_cal_status(