APPS.IGS_PS_VAL_UAI dependencies on IGS_PS_UNIT_OFR_OPT

Line 103: igs_ps_unit_ofr_opt uoo

99: SELECT 'x'
100: FROM igs_ps_unitass_item uai,
101: IGS_AS_ASSESSMNT_ITM ai,
102: IGS_AS_ASSESSMNT_TYP atyp,
103: igs_ps_unit_ofr_opt uoo
104: WHERE atyp.examinable_ind = 'N' AND
105: atyp.ASSESSMENT_TYPE = p_assessment_type AND
106: atyp.ASSESSMENT_TYPE = ai.ASSESSMENT_TYPE AND
107: uai.ass_id = ai.ass_id AND

Line 181: igs_ps_unit_ofr_opt uoo

177: SELECT 'x'
178: FROM IGS_AS_ASSESSMNT_TYP atyp,
179: IGS_AS_ASSESSMNT_ITM ai,
180: igs_ps_unitass_item uai,
181: igs_ps_unit_ofr_opt uoo
182: WHERE atyp.examinable_ind = 'Y' AND
183: ai.assessment_type = atyp.assessment_type AND
184: uai.ass_id = ai.ass_id AND
185: uoo.unit_cd = p_unit_cd AND