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.PER_EEO_MAG_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 270: hr_organization_information hoi1,

266: SUBSTR(hoi2.org_information15,1,40) email_26,
267: hoi1.organization_id par_ent_org_id
268: FROM per_gen_hierarchy_nodes pgn,
269: hr_all_organization_units hou,
270: hr_organization_information hoi1,
271: hr_organization_information hoi2,
272: hr_organization_information hoi3
273: WHERE pgn.hierarchy_version_id = p_hierarchy_version_id
274: AND pgn.node_type = 'PAR'

Line 271: hr_organization_information hoi2,

267: hoi1.organization_id par_ent_org_id
268: FROM per_gen_hierarchy_nodes pgn,
269: hr_all_organization_units hou,
270: hr_organization_information hoi1,
271: hr_organization_information hoi2,
272: hr_organization_information hoi3
273: WHERE pgn.hierarchy_version_id = p_hierarchy_version_id
274: AND pgn.node_type = 'PAR'
275: AND hou.organization_id = p_business_group_id

Line 272: hr_organization_information hoi3

268: FROM per_gen_hierarchy_nodes pgn,
269: hr_all_organization_units hou,
270: hr_organization_information hoi1,
271: hr_organization_information hoi2,
272: hr_organization_information hoi3
273: WHERE pgn.hierarchy_version_id = p_hierarchy_version_id
274: AND pgn.node_type = 'PAR'
275: AND hou.organization_id = p_business_group_id
276: AND pgn.business_group_id = p_business_group_id

Line 1947: FROM HR_ORGANIZATION_INFORMATION HOI1,

1943: AND peo.business_group_id = p_business_group_id
1944: AND job.business_group_id = p_business_group_id
1945: AND EXISTS (
1946: SELECT 'X'
1947: FROM HR_ORGANIZATION_INFORMATION HOI1,
1948: HR_ORGANIZATION_INFORMATION HOI2
1949: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1950: AND hoi1.org_information_context = 'Reporting Statuses'
1951: AND hoi1.organization_id = p_business_group_id

Line 1948: HR_ORGANIZATION_INFORMATION HOI2

1944: AND job.business_group_id = p_business_group_id
1945: AND EXISTS (
1946: SELECT 'X'
1947: FROM HR_ORGANIZATION_INFORMATION HOI1,
1948: HR_ORGANIZATION_INFORMATION HOI2
1949: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1950: AND hoi1.org_information_context = 'Reporting Statuses'
1951: AND hoi1.organization_id = p_business_group_id
1952: AND ass.employment_category = hoi2.org_information1

Line 2020: FROM hr_organization_information hoi1,

2016: AND peo.business_group_id = p_business_group_id
2017: AND job.business_group_id = p_business_group_id
2018: AND EXISTS (
2019: SELECT 'X'
2020: FROM hr_organization_information hoi1,
2021: hr_organization_information hoi2
2022: WHERE TO_CHAR(ass.assignment_status_type_id) = hoi1.org_information1
2023: AND hoi1.org_information_context = 'Reporting Statuses'
2024: AND hoi1.organization_id = p_business_group_id

Line 2021: hr_organization_information hoi2

2017: AND job.business_group_id = p_business_group_id
2018: AND EXISTS (
2019: SELECT 'X'
2020: FROM hr_organization_information hoi1,
2021: hr_organization_information hoi2
2022: WHERE TO_CHAR(ass.assignment_status_type_id) = hoi1.org_information1
2023: AND hoi1.org_information_context = 'Reporting Statuses'
2024: AND hoi1.organization_id = p_business_group_id
2025: AND ass.employment_category = hoi2.org_information1

Line 2094: FROM HR_ORGANIZATION_INFORMATION HOI1,

2090: AND peo.business_group_id = P_BUSINESS_GROUP_ID
2091: AND job.business_group_id = P_BUSINESS_GROUP_ID
2092: AND EXISTS (
2093: SELECT 'X'
2094: FROM HR_ORGANIZATION_INFORMATION HOI1,
2095: HR_ORGANIZATION_INFORMATION HOI2
2096: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2097: AND hoi1.org_information_context = 'Reporting Statuses'
2098: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 2095: HR_ORGANIZATION_INFORMATION HOI2

2091: AND job.business_group_id = P_BUSINESS_GROUP_ID
2092: AND EXISTS (
2093: SELECT 'X'
2094: FROM HR_ORGANIZATION_INFORMATION HOI1,
2095: HR_ORGANIZATION_INFORMATION HOI2
2096: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2097: AND hoi1.org_information_context = 'Reporting Statuses'
2098: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
2099: AND ass.employment_category = hoi2.org_information1

Line 2163: FROM HR_ORGANIZATION_INFORMATION HOI1,

2159: AND peo.business_group_id = P_BUSINESS_GROUP_ID
2160: AND job.business_group_id = P_BUSINESS_GROUP_ID
2161: AND EXISTS (
2162: SELECT 'X'
2163: FROM HR_ORGANIZATION_INFORMATION HOI1,
2164: HR_ORGANIZATION_INFORMATION HOI2
2165: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2166: AND hoi1.org_information_context = 'Reporting Statuses'
2167: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 2164: HR_ORGANIZATION_INFORMATION HOI2

2160: AND job.business_group_id = P_BUSINESS_GROUP_ID
2161: AND EXISTS (
2162: SELECT 'X'
2163: FROM HR_ORGANIZATION_INFORMATION HOI1,
2164: HR_ORGANIZATION_INFORMATION HOI2
2165: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2166: AND hoi1.org_information_context = 'Reporting Statuses'
2167: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
2168: AND ass.employment_category = hoi2.org_information1

Line 2433: FROM hr_organization_information

2429: BEGIN--Local1
2430: l_organization_id := l_org_rec.par_ent_org_id;
2431: SELECT 'U', org_information_id
2432: INTO p_update, l_org_information_id
2433: FROM hr_organization_information
2434: WHERE org_information1 = p_report_year
2435: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive'
2436: AND organization_id = l_org_rec.par_ent_org_id;
2437:

Line 2481: FROM hr_organization_information

2477:
2478: BEGIN --Local2
2479: SELECT object_version_number
2480: INTO l_object_version_number
2481: FROM hr_organization_information
2482: WHERE org_information_id = l_org_information_id;
2483: END;--Local2
2484:
2485: --

Line 2560: FROM hr_organization_information

2556: BEGIN--Local6
2557:
2558: SELECT count(*)
2559: INTO l_eit_count
2560: FROM hr_organization_information
2561: WHERE organization_id = p_business_group_id
2562: AND org_information_context = 'EEO_Archive';
2563: EXCEPTION
2564: WHEN NO_DATA_FOUND THEN

Line 2574: FROM hr_organization_information

2570: IF l_eit_count > 4 THEN
2571: BEGIN--Local7
2572: SELECT MIN(org_information1)
2573: INTO l_min_year
2574: FROM hr_organization_information
2575: WHERE organization_id = p_business_group_id
2576: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
2577: END;--Local7
2578:

Line 2584: FROM hr_organization_information

2580: SELECT org_information_id,
2581: object_version_number
2582: INTO l_org_information_id
2583: ,l_object_version_number
2584: FROM hr_organization_information
2585: WHERE org_information1 = l_min_year
2586: AND org_information_context = 'EEO_Archive'
2587: AND organization_id = p_business_group_id;
2588: END;--Local8