APPS.IGS_CA_VAL_DAIO dependencies on IGS_CA_INST

Line 44: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,

40: AND ((offset_dt_alias <> p_offset_dt_alias)
41: OR (offset_dai_sequence_number <> p_offset_dai_sequence_number)
42: OR (offset_cal_type <> p_offset_cal_type)
43: OR (offset_ci_sequence_number <> p_offset_ci_sequence_number));
44: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
45: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_INST

Line 45: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)

41: OR (offset_dai_sequence_number <> p_offset_dai_sequence_number)
42: OR (offset_cal_type <> p_offset_cal_type)
43: OR (offset_ci_sequence_number <> p_offset_ci_sequence_number));
44: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
45: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_INST
49: WHERE cal_type = cp_cal_type and

Line 48: FROM IGS_CA_INST

44: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
45: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
46: IS
47: SELECT *
48: FROM IGS_CA_INST
49: WHERE cal_type = cp_cal_type and
50: sequence_number = cp_sequence_number;
51: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
52: IS

Line 211: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,

207: WHERE dt_alias = p_dt_alias and
208: sequence_number = p_dai_sequence_number and
209: cal_type = p_cal_type and
210: ci_sequence_number = p_ci_sequence_number;
211: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
212: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
213: IS
214: SELECT *
215: FROM IGS_CA_INST

Line 212: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)

208: sequence_number = p_dai_sequence_number and
209: cal_type = p_cal_type and
210: ci_sequence_number = p_ci_sequence_number;
211: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
212: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
213: IS
214: SELECT *
215: FROM IGS_CA_INST
216: WHERE cal_type = cp_cal_type and

Line 215: FROM IGS_CA_INST

211: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
212: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
213: IS
214: SELECT *
215: FROM IGS_CA_INST
216: WHERE cal_type = cp_cal_type and
217: sequence_number = cp_sequence_number;
218: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
219: IS