APPS.AD_MORG dependencies on HR_OPERATING_UNITS

Line 15: from hr_operating_units

11: -- in replicate_table_data_bulk().
12: --
13: cursor org_cursor is
14: select organization_id
15: from hr_operating_units
16: , fnd_product_groups
17: where product_group_id = 1
18: and multi_org_flag = 'Y'
19: union

Line 604: ' fnd_product_groups, hr_operating_units' ||

600: raise table_not_found;
601: end if;
602:
603: in_line_view := ' (SELECT /*+ no_merge */ ORGANIZATION_ID FROM' ||
604: ' fnd_product_groups, hr_operating_units' ||
605: ' WHERE product_group_id = 1' ||
606: ' AND multi_org_flag = ''Y'' UNION' ||
607: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
608: ' (SELECT NULL FROM fnd_product_groups WHERE' ||

Line 1612: from hr_operating_units

1608: begin
1609:
1610: select count(*)
1611: into l_num_org
1612: from hr_operating_units
1613: , fnd_product_groups
1614: where product_group_id = 1
1615: and multi_org_flag = 'Y';
1616:

Line 1856: from HR_OPERATING_UNITS where

1852: nvl(owner, 'null') = nvl(owner, 'null');
1853: if (cnt > 0)
1854: then
1855: select SET_OF_BOOKS_ID into book_id
1856: from HR_OPERATING_UNITS where
1857: ORGANIZATION_ID=X_org_id;
1858: id := to_number(book_id);
1859: if (id > 1) then
1860: stmt:= 'update ' || X_table_name || ' set SET_OF_BOOKS_ID='||book_id||