DBA Data[Home] [Help]

APPS.IGS_PS_VAL_UAI dependencies on IGS_PS_UNITASS_ITEM

Line 100: FROM igs_ps_unitass_item uai,

96: -- only for items that have not been deleted
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

Line 180: igs_ps_unitass_item uai,

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
184: uai.ass_id = ai.ass_id AND