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_SYNC_ORGS dependencies on HR_ORGANIZATION_INFORMATION

Line 658: , hr_organization_information CLASS

654: , cp_co IN VARCHAR2
655: ) IS
656: SELECT DISTINCT UNITS.business_group_id
657: FROM hr_all_organization_units UNITS
658: , hr_organization_information CLASS
659: , hr_organization_information CC
660: WHERE UNITS.organization_id = CLASS.organization_id
661: AND CLASS.org_information_context = 'CLASS'
662: AND CLASS.org_information1 = 'CC'

Line 659: , hr_organization_information CC

655: ) IS
656: SELECT DISTINCT UNITS.business_group_id
657: FROM hr_all_organization_units UNITS
658: , hr_organization_information CLASS
659: , hr_organization_information CC
660: WHERE UNITS.organization_id = CLASS.organization_id
661: AND CLASS.org_information_context = 'CLASS'
662: AND CLASS.org_information1 = 'CC'
663: AND CLASS.organization_id = CC.organization_id

Line 787: FROM hr_organization_information

783: SELECT org_information2
784: , org_information3
785: , org_information4
786: , org_information5
787: FROM hr_organization_information
788: WHERE organization_id = p_org_id
789: AND org_information_context = 'Company Cost Center';
790:
791: BEGIN

Line 836: FROM hr_organization_information

832:
833: -- Cursor to check if classification exists
834: CURSOR c_chk_hr_org_class IS
835: SELECT 1
836: FROM hr_organization_information
837: WHERE organization_id = p_org_id
838: --AND org_information_context = 'HR_ORG';
839: AND org_information_context = 'CLASS'
840: AND org_information1 = 'HR_ORG';

Line 891: FROM hr_organization_information

887: CURSOR c_chk_co_cc_class IS
888: SELECT org_information2
889: ,org_information_id
890: ,object_version_number
891: FROM hr_organization_information
892: WHERE organization_id = p_org_id
893: AND org_information_context = 'CLASS'
894: AND org_information1 = 'CC';
895:

Line 1483: l_class_enabled hr_organization_information.org_information2%TYPE;

1479: l_org_name hr_all_organization_units.name%TYPE;
1480: l_new_org_name hr_all_organization_units.name%TYPE;
1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1483: l_class_enabled hr_organization_information.org_information2%TYPE;
1484: l_class_id hr_organization_information.org_information_id%TYPE;
1485: l_class_ovn hr_organization_information.object_version_number%TYPE;
1486: l_co VARCHAR2(240);
1487: l_cc VARCHAR2(240);

Line 1484: l_class_id hr_organization_information.org_information_id%TYPE;

1480: l_new_org_name hr_all_organization_units.name%TYPE;
1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1483: l_class_enabled hr_organization_information.org_information2%TYPE;
1484: l_class_id hr_organization_information.org_information_id%TYPE;
1485: l_class_ovn hr_organization_information.object_version_number%TYPE;
1486: l_co VARCHAR2(240);
1487: l_cc VARCHAR2(240);
1488: l_co_vs_id NUMBER(15); -- Id of company value set

Line 1485: l_class_ovn hr_organization_information.object_version_number%TYPE;

1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1483: l_class_enabled hr_organization_information.org_information2%TYPE;
1484: l_class_id hr_organization_information.org_information_id%TYPE;
1485: l_class_ovn hr_organization_information.object_version_number%TYPE;
1486: l_co VARCHAR2(240);
1487: l_cc VARCHAR2(240);
1488: l_co_vs_id NUMBER(15); -- Id of company value set
1489: l_cc_vs_id NUMBER(15); -- Id of cost center value set

Line 1879: ' hr_organization_information cc,'||

1875: -- Update will only be done if new and existing values differ.
1876: open c_ref for ' select units.rowid, units.name, units.organization_id, units.date_from, units.date_to, '||
1877: ' t.co_vs_id, t.co, t.cc_vs_id, t.cc'||
1878: ' from '|| g_temp_table_name ||' t , '||
1879: ' hr_organization_information cc,'||
1880: ' hr_organization_information class,'||
1881: ' hr_all_organization_units units'||
1882: ' where to_char(t.co_vs_id) = cc.org_information2 '||
1883: ' and t.co = cc.org_information3 '||

Line 1880: ' hr_organization_information class,'||

1876: open c_ref for ' select units.rowid, units.name, units.organization_id, units.date_from, units.date_to, '||
1877: ' t.co_vs_id, t.co, t.cc_vs_id, t.cc'||
1878: ' from '|| g_temp_table_name ||' t , '||
1879: ' hr_organization_information cc,'||
1880: ' hr_organization_information class,'||
1881: ' hr_all_organization_units units'||
1882: ' where to_char(t.co_vs_id) = cc.org_information2 '||
1883: ' and t.co = cc.org_information3 '||
1884: ' and to_char(t.cc_vs_id) = cc.org_information4 '||

Line 2038: hr_organization_information class,

2034: ,cp_business_group_id in number
2035: ,cp_co_vs_id in number) is
2036: select distinct cc.org_information3 company_code
2037: from hr_all_organization_units units,
2038: hr_organization_information class,
2039: hr_organization_information cc
2040: where units.organization_id = class.organization_id
2041: and class.org_information_context = 'CLASS'
2042: and class.org_information1 = 'CC'

Line 2039: hr_organization_information cc

2035: ,cp_co_vs_id in number) is
2036: select distinct cc.org_information3 company_code
2037: from hr_all_organization_units units,
2038: hr_organization_information class,
2039: hr_organization_information cc
2040: where units.organization_id = class.organization_id
2041: and class.org_information_context = 'CLASS'
2042: and class.org_information1 = 'CC'
2043: and class.organization_id = cc.organization_id

Line 2163: ' hr_organization_information class,'||

2159: execute immediate 'delete from '||g_temp_table_name||
2160: ' where (co,to_char(co_vs_id)) not in ('||
2161: ' select distinct cc.org_information3, cc.org_information2'||
2162: ' from hr_all_organization_units units,'||
2163: ' hr_organization_information class,'||
2164: ' hr_organization_information cc'||
2165: ' where units.organization_id = class.organization_id'||
2166: ' and class.org_information_context = ''CLASS'''||
2167: ' and class.org_information1 = ''CC'''||

Line 2164: ' hr_organization_information cc'||

2160: ' where (co,to_char(co_vs_id)) not in ('||
2161: ' select distinct cc.org_information3, cc.org_information2'||
2162: ' from hr_all_organization_units units,'||
2163: ' hr_organization_information class,'||
2164: ' hr_organization_information cc'||
2165: ' where units.organization_id = class.organization_id'||
2166: ' and class.org_information_context = ''CLASS'''||
2167: ' and class.org_information1 = ''CC'''||
2168: ' and class.organization_id = cc.organization_id'||

Line 2310: ' hr_organization_information CLASS,'||

2306: ', TO_CHAR(cc_vs_id), cc) IN ('||
2307: ' SELECT CC.org_information2, CC.org_information3,'||
2308: ' CC.org_information4, CC.org_information5'||
2309: ' FROM hr_all_organization_units UNITS,'||
2310: ' hr_organization_information CLASS,'||
2311: ' hr_organization_information CC'||
2312: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2313: ' AND CLASS.org_information_context = ''CLASS'''||
2314: ' AND CLASS.org_information1 = ''CC'''||

Line 2311: ' hr_organization_information CC'||

2307: ' SELECT CC.org_information2, CC.org_information3,'||
2308: ' CC.org_information4, CC.org_information5'||
2309: ' FROM hr_all_organization_units UNITS,'||
2310: ' hr_organization_information CLASS,'||
2311: ' hr_organization_information CC'||
2312: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2313: ' AND CLASS.org_information_context = ''CLASS'''||
2314: ' AND CLASS.org_information1 = ''CC'''||
2315: ' AND CLASS.organization_id = CC.organization_id'||

Line 2425: ,hr_organization_information CLASS

2421: , cp_co_vs_id IN NUMBER
2422: ) IS
2423: SELECT DISTINCT CC.org_information3 company_code
2424: FROM hr_all_organization_units UNITS
2425: ,hr_organization_information CLASS
2426: ,hr_organization_information CC
2427: WHERE UNITS.organization_id = CLASS.organization_id
2428: AND CLASS.org_information_context = 'CLASS'
2429: AND CLASS.org_information1 = 'CC'

Line 2426: ,hr_organization_information CC

2422: ) IS
2423: SELECT DISTINCT CC.org_information3 company_code
2424: FROM hr_all_organization_units UNITS
2425: ,hr_organization_information CLASS
2426: ,hr_organization_information CC
2427: WHERE UNITS.organization_id = CLASS.organization_id
2428: AND CLASS.org_information_context = 'CLASS'
2429: AND CLASS.org_information1 = 'CC'
2430: AND CLASS.organization_id = CC.organization_id

Line 2561: ' hr_organization_information CLASS,'||

2557: EXECUTE IMMEDIATE 'DELETE FROM '||g_temp_table_name||
2558: ' WHERE (co,TO_CHAR(co_vs_id)) NOT IN ('||
2559: ' SELECT DISTINCT CC.org_information3, CC.org_information2'||
2560: ' FROM hr_all_organization_units UNITS,'||
2561: ' hr_organization_information CLASS,'||
2562: ' hr_organization_information CC'||
2563: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2564: ' AND CLASS.org_information_context = ''CLASS'''||
2565: ' AND CLASS.org_information1 = ''CC'''||

Line 2562: ' hr_organization_information CC'||

2558: ' WHERE (co,TO_CHAR(co_vs_id)) NOT IN ('||
2559: ' SELECT DISTINCT CC.org_information3, CC.org_information2'||
2560: ' FROM hr_all_organization_units UNITS,'||
2561: ' hr_organization_information CLASS,'||
2562: ' hr_organization_information CC'||
2563: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2564: ' AND CLASS.org_information_context = ''CLASS'''||
2565: ' AND CLASS.org_information1 = ''CC'''||
2566: ' AND CLASS.organization_id = CC.organization_id'||

Line 2617: ' hr_organization_information CC,'||

2613: -- Update will only be done if new and existing values differ.
2614: OPEN c_ref FOR ' SELECT UNITS.ROWID, UNITS.name, UNITS.date_from, UNITS.date_to, '||
2615: ' t.CO_VS_ID, t.CO, t.CC_VS_ID, t.CC'||
2616: ' FROM '|| g_temp_table_name ||' t , '||
2617: ' hr_organization_information CC,'||
2618: ' hr_organization_information CLASS,'||
2619: ' hr_all_organization_units UNITS'||
2620: ' WHERE TO_CHAR(t.co_vs_id) = CC.org_information2 '||
2621: ' AND t.co = CC.org_information3 '||

Line 2618: ' hr_organization_information CLASS,'||

2614: OPEN c_ref FOR ' SELECT UNITS.ROWID, UNITS.name, UNITS.date_from, UNITS.date_to, '||
2615: ' t.CO_VS_ID, t.CO, t.CC_VS_ID, t.CC'||
2616: ' FROM '|| g_temp_table_name ||' t , '||
2617: ' hr_organization_information CC,'||
2618: ' hr_organization_information CLASS,'||
2619: ' hr_all_organization_units UNITS'||
2620: ' WHERE TO_CHAR(t.co_vs_id) = CC.org_information2 '||
2621: ' AND t.co = CC.org_information3 '||
2622: ' AND TO_CHAR(t.cc_vs_id) = CC.org_information4 '||

Line 2749: ' hr_organization_information CLASS,'||

2745: ', TO_CHAR(cc_vs_id), cc) IN ('||
2746: ' SELECT CC.org_information2, CC.org_information3,'||
2747: ' CC.org_information4, CC.org_information5'||
2748: ' FROM hr_all_organization_units UNITS,'||
2749: ' hr_organization_information CLASS,'||
2750: ' hr_organization_information CC'||
2751: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2752: ' AND CLASS.org_information_context = ''CLASS'''||
2753: ' AND CLASS.org_information1 = ''CC'''||

Line 2750: ' hr_organization_information CC'||

2746: ' SELECT CC.org_information2, CC.org_information3,'||
2747: ' CC.org_information4, CC.org_information5'||
2748: ' FROM hr_all_organization_units UNITS,'||
2749: ' hr_organization_information CLASS,'||
2750: ' hr_organization_information CC'||
2751: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2752: ' AND CLASS.org_information_context = ''CLASS'''||
2753: ' AND CLASS.org_information1 = ''CC'''||
2754: ' AND CLASS.organization_id = CC.organization_id'||

Line 2906: ', hr_organization_information CLASS'||

2902: ', CC.org_information3'||
2903: ', CC.org_information4'||
2904: ', CC.org_information5'||
2905: ' FROM hr_all_organization_units UNITS'||
2906: ', hr_organization_information CLASS'||
2907: ', hr_organization_information CC'||
2908: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2909: ' AND CLASS.org_information_context = ''CLASS'''||
2910: ' AND CLASS.org_information1 = ''CC'''||

Line 2907: ', hr_organization_information CC'||

2903: ', CC.org_information4'||
2904: ', CC.org_information5'||
2905: ' FROM hr_all_organization_units UNITS'||
2906: ', hr_organization_information CLASS'||
2907: ', hr_organization_information CC'||
2908: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2909: ' AND CLASS.org_information_context = ''CLASS'''||
2910: ' AND CLASS.org_information1 = ''CC'''||
2911: ' AND CLASS.organization_id = CC.organization_id'||

Line 2941: ', hr_organization_information CLASS'||

2937: ', CC.org_information3'||
2938: ', CC.org_information4'||
2939: ', CC.org_information5'||
2940: ' FROM hr_all_organization_units UNITS'||
2941: ', hr_organization_information CLASS'||
2942: ', hr_organization_information CC'||
2943: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2944: ' AND CLASS.org_information_context = ''CLASS'''||
2945: ' AND CLASS.org_information1 = ''CC'''||

Line 2942: ', hr_organization_information CC'||

2938: ', CC.org_information4'||
2939: ', CC.org_information5'||
2940: ' FROM hr_all_organization_units UNITS'||
2941: ', hr_organization_information CLASS'||
2942: ', hr_organization_information CC'||
2943: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2944: ' AND CLASS.org_information_context = ''CLASS'''||
2945: ' AND CLASS.org_information1 = ''CC'''||
2946: ' AND CLASS.organization_id = CC.organization_id'||

Line 3333: ', hr_organization_information CLASS'||

3329: IF l_retcode = 0 THEN
3330: hr_utility.set_location(l_proc, 70);
3331: OPEN c_list FOR 'SELECT UNITS.organization_id'||
3332: ' FROM hr_all_organization_units UNITS'||
3333: ', hr_organization_information CLASS'||
3334: ', hr_organization_information CC'||
3335: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3336: ' AND CLASS.org_information_context = ''CLASS'''||
3337: ' AND CLASS.org_information1 = ''CC'''||

Line 3334: ', hr_organization_information CC'||

3330: hr_utility.set_location(l_proc, 70);
3331: OPEN c_list FOR 'SELECT UNITS.organization_id'||
3332: ' FROM hr_all_organization_units UNITS'||
3333: ', hr_organization_information CLASS'||
3334: ', hr_organization_information CC'||
3335: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3336: ' AND CLASS.org_information_context = ''CLASS'''||
3337: ' AND CLASS.org_information1 = ''CC'''||
3338: ' AND CLASS.organization_id = CC.organization_id'||

Line 3552: ', hr_organization_information CLASS'||

3548: EXECUTE IMMEDIATE 'UPDATE '||g_temp_table_name||' TEMP'||
3549: ' SET TEMP.org_id ='||
3550: ' (SELECT UNITS.organization_id'||
3551: ' FROM hr_all_organization_units UNITS'||
3552: ', hr_organization_information CLASS'||
3553: ', hr_organization_information CC'||
3554: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3555: ' AND CLASS.org_information_context = ''CLASS'''||
3556: ' AND CLASS.org_information1 = ''CC'''||

Line 3553: ', hr_organization_information CC'||

3549: ' SET TEMP.org_id ='||
3550: ' (SELECT UNITS.organization_id'||
3551: ' FROM hr_all_organization_units UNITS'||
3552: ', hr_organization_information CLASS'||
3553: ', hr_organization_information CC'||
3554: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3555: ' AND CLASS.org_information_context = ''CLASS'''||
3556: ' AND CLASS.org_information1 = ''CC'''||
3557: ' AND CLASS.organization_id = CC.organization_id'||