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.

APPS.HR_GL_COST_CENTERS dependencies on HR_ORGANIZATION_INFORMATION

Line 586: from hr_organization_information ori

582:
583: cursor csr_chk_org_class(p_organization_id number,
584: p_classification varchar2) is
585: select org_information2, org_information_id, object_version_number
586: from hr_organization_information ori
587: where organization_id = p_organization_id
588: and org_information_context = 'CLASS'
589: and org_information1 = p_classification;
590:

Line 597: from hr_organization_information ori

593: select org_information2,
594: org_information3,
595: org_information4,
596: org_information5
597: from hr_organization_information ori
598: where organization_id = p_organization_id
599: and org_information_context = p_info_type;
600:
601: BEGIN

Line 672: hr_organization_information class,

668:
669: l_organization_id := -1;
670: open c_list for 'select units.organization_id, units.name
671: from hr_all_organization_units_tl units,
672: hr_organization_information class,
673: hr_organization_information cc
674: where units.organization_id = class.organization_id
675: and class.org_information_context=''CLASS''
676: and class.org_information1=''CC''

Line 673: hr_organization_information cc

669: l_organization_id := -1;
670: open c_list for 'select units.organization_id, units.name
671: from hr_all_organization_units_tl units,
672: hr_organization_information class,
673: hr_organization_information cc
674: where units.organization_id = class.organization_id
675: and class.org_information_context=''CLASS''
676: and class.org_information1=''CC''
677: and class.organization_id = cc.organization_id

Line 1348: hr_organization_information class,

1344:
1345: cursor company_bg is
1346: select distinct units.business_group_id
1347: from hr_all_organization_units units,
1348: hr_organization_information class,
1349: hr_organization_information cc
1350: where units.organization_id = class.organization_id
1351: and class.org_information_context='CLASS'
1352: and class.org_information1='CC'

Line 1349: hr_organization_information cc

1345: cursor company_bg is
1346: select distinct units.business_group_id
1347: from hr_all_organization_units units,
1348: hr_organization_information class,
1349: hr_organization_information cc
1350: where units.organization_id = class.organization_id
1351: and class.org_information_context='CLASS'
1352: and class.org_information1='CC'
1353: and class.organization_id = cc.organization_id

Line 1637: hr_organization_information class,

1633: ( select distinct cc.org_information3,
1634: cc.org_information2
1635: from hr_all_organization_units units,
1636: hr_all_organization_units_tl unitstl,
1637: hr_organization_information class,
1638: hr_organization_information cc
1639: where units.organization_id = class.organization_id
1640: and units.organization_id = unitstl.organization_id
1641: and class.org_information_context=''CLASS''

Line 1638: hr_organization_information cc

1634: cc.org_information2
1635: from hr_all_organization_units units,
1636: hr_all_organization_units_tl unitstl,
1637: hr_organization_information class,
1638: hr_organization_information cc
1639: where units.organization_id = class.organization_id
1640: and units.organization_id = unitstl.organization_id
1641: and class.org_information_context=''CLASS''
1642: and class.org_information1=''CC''

Line 1874: hr_organization_information class,

1870: ( select distinct cc.org_information3,
1871: cc.org_information2
1872: from hr_all_organization_units units,
1873: hr_all_organization_units_tl unitstl,
1874: hr_organization_information class,
1875: hr_organization_information cc
1876: where units.organization_id = class.organization_id
1877: and units.organization_id = unitstl.organization_id
1878: and class.org_information_context=''CLASS''

Line 1875: hr_organization_information cc

1871: cc.org_information2
1872: from hr_all_organization_units units,
1873: hr_all_organization_units_tl unitstl,
1874: hr_organization_information class,
1875: hr_organization_information cc
1876: where units.organization_id = class.organization_id
1877: and units.organization_id = unitstl.organization_id
1878: and class.org_information_context=''CLASS''
1879: and class.org_information1=''CC''

Line 1925: hr_organization_information class,

1921: (select sync.ccid,
1922: units.organization_id
1923: from '||p_hr_sync_temp ||' sync ,
1924: hr_all_organization_units units,
1925: hr_organization_information class,
1926: hr_organization_information cc
1927: where units.organization_id = class.organization_id
1928: and units.business_group_id = '||p_bgid||'
1929: and class.org_information_context=''CLASS''

Line 1926: hr_organization_information cc

1922: units.organization_id
1923: from '||p_hr_sync_temp ||' sync ,
1924: hr_all_organization_units units,
1925: hr_organization_information class,
1926: hr_organization_information cc
1927: where units.organization_id = class.organization_id
1928: and units.business_group_id = '||p_bgid||'
1929: and class.org_information_context=''CLASS''
1930: and class.org_information1=''CC''

Line 2373: hr_organization_information class,

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,
2374: hr_organization_information cc
2375: where units.organization_id = class.organization_id
2376: and class.org_information_context=''CLASS''
2377: and class.org_information1=''CC''

Line 2374: hr_organization_information cc

2370: --
2371: open c_list for 'select units.organization_id
2372: from hr_all_organization_units units,
2373: hr_organization_information class,
2374: hr_organization_information cc
2375: where units.organization_id = class.organization_id
2376: and class.org_information_context=''CLASS''
2377: and class.org_information1=''CC''
2378: and class.organization_id = cc.organization_id