APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 82: FROM igs_ps_unit_ofr_opt

78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE
80: ) IS
81: SELECT uoo_id
82: FROM igs_ps_unit_ofr_opt
83: WHERE unit_cd = cp_unit_cd
84: --AND version_number = cp_version_number
85: AND cal_type = cp_cal_type
86: AND ci_sequence_number = cp_ci_sequence_number

Line 635: igs_ps_unit_ofr_opt uoo

631: OR p_ass_id IS NULL
632: )
633: AND (EXISTS ( SELECT 'X'
634: FROM igs_ps_unitass_item uooai,
635: igs_ps_unit_ofr_opt uoo
636: WHERE uoo.uoo_id = cp_uoo_id
637: AND uooai.uoo_id = uoo.uoo_id
638: AND uooai.ass_id = ai.ass_id
639: AND uooai.logical_delete_dt IS NULL

Line 647: igs_ps_unit_ofr_opt uoo

643: AND uooai.grading_schema_cd = gs.grading_schema_cd
644: AND uooai.gs_version_number = gs.version_number)
645: OR EXISTS ( SELECT 'X'
646: FROM igs_as_unitass_item uoai,
647: igs_ps_unit_ofr_opt uoo
648: WHERE uoo.uoo_id = cp_uoo_id
649: AND uoai.unit_cd = uoo.unit_cd
650: AND uoai.version_number = uoo.version_number
651: AND uoai.cal_type = uoo.cal_type

Line 895: -- required to be derived from the tables based on PK of IGS_PS_UNIT_OFR_OPT_ALL.

891: is blank and assessment type or reference is blank give error or get the value for assessment id
892: based on assessment type and reference. FIRST GET UOO_ID
893: */
894: -- As per bug# 2735673 The uoo_id column has been added to the interface table. UOO_ID is not
895: -- required to be derived from the tables based on PK of IGS_PS_UNIT_OFR_OPT_ALL.
896: --Still Keeping this query in case user has not entered the UOO_ID in the spreadsheet).
897: IF p_uoo_id IS NULL THEN
898: OPEN c_uoo_id (p_cal_type, p_ci_sequence_number, p_person_id);
899: FETCH c_uoo_id INTO v_uoo_id;