DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_AS_USECAI_SUA_V

Line 9841: FROM igs_as_usecai_sua_v

9837: CURSOR c_usec_level (cp_person_id NUMBER,
9838: cp_dest_course_cd VARCHAR2,
9839: cp_dest_uoo_id NUMBER) IS
9840: SELECT COUNT (person_id)
9841: FROM igs_as_usecai_sua_v
9842: WHERE person_id = cp_person_id
9843: AND course_cd = cp_dest_course_cd
9844: AND uoo_id = cp_dest_uoo_id
9845: AND usai_logical_delete_dt IS NULL;