APPS.IGS_AD_VAL_ACAIU dependencies on IGS_PS_UNIT_OFR_OPT

Line 108: FROM IGS_PS_UNIT_OFR_OPT uoo,

104: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
105: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
106: SELECT DISTINCT uoo.cal_type,
107: uoo.ci_sequence_number
108: FROM IGS_PS_UNIT_OFR_OPT uoo,
109: IGS_CA_INST_REL cir
110: WHERE uoo.unit_cd = cp_unit_cd AND
111: uoo.version_number = cp_uv_version_number AND
112: uoo.offered_ind = cst_yes AND

Line 239: FROM IGS_PS_UNIT_OFR_OPT uoo

235: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
236: cp_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
237: SELECT uoo.offered_ind,
238: uoo.unit_class
239: FROM IGS_PS_UNIT_OFR_OPT uoo
240: WHERE uoo.unit_cd = p_unit_cd AND
241: uoo.version_number = p_uv_version_number AND
242: uoo.cal_type = cp_cal_type AND
243: uoo.ci_sequence_number = cp_ci_sequence_number AND

Line 267: EXIT; --(IGS_PS_UNIT_OFR_OPT)

263: p_unit_mode,
264: v_message_name) = TRUE THEN
265: -- A valid offered option exists
266: v_offered_optn_found := TRUE;
267: EXIT; --(IGS_PS_UNIT_OFR_OPT)
268: END IF;
269: ELSE
270: -- A valid offered option exists
271: v_offered_optn_found := TRUE;

Line 272: EXIT; --(IGS_PS_UNIT_OFR_OPT)

268: END IF;
269: ELSE
270: -- A valid offered option exists
271: v_offered_optn_found := TRUE;
272: EXIT; --(IGS_PS_UNIT_OFR_OPT)
273: END IF;
274: END IF;
275: END LOOP;
276: IF (v_val_optn_found = FALSE OR

Line 813: FROM IGS_PS_UNIT_OFR_OPT uoo

809: CURSOR c_uoo (
810: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
811: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
812: SELECT 'x'
813: FROM IGS_PS_UNIT_OFR_OPT uoo
814: WHERE uoo.unit_cd = p_unit_cd AND
815: uoo.version_number = p_uv_version_number AND
816: uoo.cal_type = cp_cal_type AND
817: uoo.ci_sequence_number = cp_sequence_number AND