APPS.IGS_PS_VAL_UAI dependencies on IGS_CA_STAT

Line 37: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

33: (reverse chronological order - newest change first)
34: ***************************************************************/
35:
36: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
37: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status

Line 41: SELECT IGS_CA_STAT.s_cal_status

37: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

Line 42: FROM IGS_CA_INST, IGS_CA_STAT

38: CURSOR c_cal_status(
39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,
40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS
41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);

Line 45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

41: SELECT IGS_CA_STAT.s_cal_status
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
44: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
45: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
46: v_other_detail VARCHAR2(255);
47: BEGIN
48: P_MESSAGE_NAME := null;
49: OPEN c_cal_status(