DBA Data[Home] [Help]

APPS.IGS_PS_VAL_UAI dependencies on IGS_AS_ASSESSMNT_ITM

Line 101: IGS_AS_ASSESSMNT_ITM ai,

97: DECLARE
98: CURSOR c_uai IS
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

Line 179: IGS_AS_ASSESSMNT_ITM ai,

175: DECLARE
176: CURSOR c_uai IS
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