DBA Data[Home] [Help]

APPS.IGS_AS_VAL_SUAAI dependencies on IGS_EN_SU_ATTEMPT

Line 238: IGS_EN_SU_ATTEMPT sua,

234:
235: CURSOR c_suv IS
236: SELECT uai.logical_delete_dt
237: FROM
238: IGS_EN_SU_ATTEMPT sua,
239: IGS_AS_UNITASS_ITEM uai
240: WHERE sua.person_id = p_person_id AND
241: sua.course_cd = p_course_cd AND
242: -- anilk, 22-Apr-2003, Bug# 2829262

Line 255: IGS_EN_SU_ATTEMPT sua,

251: sua.course_cd) = 'TRUE'
252: UNION
253: SELECT psuai.logical_delete_dt
254: FROM
255: IGS_EN_SU_ATTEMPT sua,
256: IGS_PS_UNITASS_ITEM_V psuai
257: WHERE sua.person_id = p_person_id AND
258: sua.course_cd = p_course_cd AND
259: -- anilk, 22-Apr-2003, Bug# 2829262