eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_JP_REPORT_COMMON_PKG dependencies on HR_ORGANIZATION_UNITS

Line 55: FROM hr_organization_units

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);
57: --
58: -- bug # 8667163 -Modified to get all the organizations related to a Organization Passed as a parameter.
59: CURSOR lcu_org_hierarchy_nn