APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HR_OPERATING_UNITS

Line 393: SELECT organization_id from hr_operating_units where

389: l_out_oracle_schema varchar2(100);
390: x boolean;
391:
392: CURSOR c_org(c_org_id number) IS
393: SELECT organization_id from hr_operating_units where
394: mo_global.check_access(organization_id) = 'Y'
395: AND organization_id = nvl(c_org_id,organization_id);
396:
397: --Begin Bug 8942646 12-Oct-2009 barathsr

Line 748: SELECT organization_id from hr_operating_units where

744: and enabled_flag='Y'
745: order by nvl(org_id,0) desc ;
746:
747: CURSOR c_org(c_org_id number) IS
748: SELECT organization_id from hr_operating_units where
749: mo_global.check_access(organization_id) = 'Y'
750: AND organization_id = nvl(c_org_id,organization_id);
751:
752: l_allowed_lvl varchar2(20);

Line 13523: SELECT organization_id from hr_operating_units where

13519: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
13520: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
13521:
13522: CURSOR c_org(c_org_id number) IS
13523: SELECT organization_id from hr_operating_units where
13524: mo_global.check_access(organization_id) = 'Y'
13525: AND organization_id = nvl(c_org_id,organization_id);
13526:
13527: BEGIN