DBA Data[Home] [Help]

APPS.PER_JP_REPORT_COMMON_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 52: FROM hr_all_organization_units

48: -- bug # 8667163 -Modified to get all the organizations related to a Business Group
49: CURSOR lcu_org_hierarchy
50: IS
51: SELECT organization_id
52: FROM hr_all_organization_units
53: WHERE business_group_id=p_business_group_id
54: AND organization_id NOT IN(SELECT business_group_id
55: FROM hr_organization_units
56: WHERE business_group_id=p_business_group_id);