APPS.IGS_PS_VAL_UAI dependencies on IGS_CA_INST_ALL

Line 39: cp_cal_type IGS_CA_INST_ALL.cal_type%TYPE,

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
42: FROM IGS_CA_INST, IGS_CA_STAT
43: WHERE IGS_CA_INST.cal_type = cp_cal_type AND

Line 40: cp_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE) IS

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
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