DBA Data[Home] [Help]

APPS.IGS_AD_UNIT_SETS_PKG dependencies on IGS_EN_UNIT_SET_STAT

Line 438: FROM igs_en_unit_set_stat uss

434: AND psus.admission_cat = p_admission_cat
435: )
436: AND psusv.UNIT_SET_STATUS IN
437: (SELECT unit_set_status
438: FROM igs_en_unit_set_stat uss
439: WHERE psusv.unit_set_status = uss.unit_set_status
440: AND uss.s_unit_set_status <> 'INACTIVE'
441: )
442: AND psusv.unit_set_cat IN

Line 466: FROM igs_en_unit_set_stat uss

462: AND psus.attendance_type = nvl(p_attendance_type , psus.attendance_type)
463: AND psus.admission_cat = p_admission_cat
464: AND us.unit_set_status IN
465: (SELECT unit_set_status
466: FROM igs_en_unit_set_stat uss
467: WHERE us.unit_set_status = uss.unit_set_status
468: AND uss.s_unit_set_status <> 'INACTIVE'
469: )
470: AND us.unit_set_cat IN