DBA Data[Home] [Help]

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 580: ' fnd_product_groups, hr_operating_units' ||

576: c_pk.column_name || ' = A.' || c_pk.column_name;
577: end loop;
578:
579: in_line_view := ' (SELECT /*+ no_merge */ ORGANIZATION_ID FROM' ||
580: ' fnd_product_groups, hr_operating_units' ||
581: ' WHERE product_group_id = 1' ||
582: ' AND multi_org_flag = ''Y'' UNION' ||
583: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
584: ' (SELECT NULL FROM fnd_product_groups WHERE' ||

Line 1570: from hr_operating_units

1566: begin
1567:
1568: select count(*)
1569: into l_num_org
1570: from hr_operating_units
1571: , fnd_product_groups
1572: where product_group_id = 1
1573: and multi_org_flag = 'Y';
1574: