APPS.HR_GL_COST_CENTERS dependencies on DUAL

Line 780: from dual;

776: '$CCC', p_cost_center),
777: '$CON', l_company_desc),
778: '$CCN', l_cc_desc), 1, g_org_name_length)
779: into l_org_name
780: from dual;
781:
782: hr_utility.set_location(l_proc,120);
783: l_org_name := substrb(l_org_name, 1, g_org_name_length);
784: l_orig_org_name := l_org_name;

Line 1686: from dual)';

1682: ''$CCC'', rep.cost_center),
1683: ''$CON'', rep.company_name),
1684: ''$CCN'', rep.cost_center_name), 1,
1685: :g_org_name_length)
1686: from dual)';
1687:
1688: execute immediate l_stmt using l_org_name_format, g_org_name_length;
1689: hr_utility.set_location(l_proc,80);
1690:

Line 1916: ** the individual segments.

1912: ** and valueset details then link the org to the GL code combinations
1913: ** record.
1914: **
1915: ** This SQL needs rewriting to use org_information1 in the search and not
1916: ** the individual segments.
1917: */
1918: hr_utility.set_location(l_proc,66);
1919:
1920: l_stmt := 'create table '||p_hr_sync_ccid||'(ccid, org_id) as

Line 2369: -- individual segment values.

2365: writelog('Checking to see if an Org already exists for the combination' ,'D');
2366:
2367: --
2368: -- This SQL needs to be tuned to use org_information1 rather than the
2369: -- individual segment values.
2370: --
2371: open c_list for 'select units.organization_id
2372: from hr_all_organization_units units,
2373: hr_organization_information class,