DBA Data[Home] [Help]

APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_PS_UNIT_OFR_OPT

Line 290: IGS_PS_UNIT_OFR_OPT uoo

286: uoo.uoo_id,
287: sua.sup_unit_cd
288: FROM IGS_EN_SU_ATTEMPT sua,
289: IGS_CA_INST ci,
290: IGS_PS_UNIT_OFR_OPT uoo
291: WHERE
292: sua.person_id = p_person_id
293: AND sua.course_cd = p_course_cd
294: AND sua.unit_attempt_status = 'ENROLLED'

Line 811: IGS_PS_UNIT_OFR_OPT uoo

807: sua.sup_unit_cd
808: FROM IGS_EN_SU_ATTEMPT sua,
809: IGS_EN_STDNT_PS_ATT sca,
810: IGS_CA_INST ci ,
811: IGS_PS_UNIT_OFR_OPT uoo
812: WHERE sua.person_id = p_person_id
813: AND sua.course_cd = p_course_cd
814: AND sua.unit_attempt_status = 'INVALID'
815: AND sca.person_id = sua.person_id