DBA Data[Home] [Help]

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 2469: HR_ORGANIZATION_UNITS org,

2465: SELECT count(a.user_group_element_id) into restricted_elements_count
2466: FROM OTA_USER_GROUP_ELEMENTS a,
2467: PER_PEOPLE_F e,
2468: PER_JOBS_VL job,
2469: HR_ORGANIZATION_UNITS org,
2470: PER_POSITIONS pos
2471: WHERE a.user_group_id in ( SELECT child_user_group_id
2472: FROM ( SELECT a.child_user_group_id
2473: FROM ota_user_group_elements a,