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 1999: FROM HR_ORGANIZATION_INFORMATION HOI1,

1995: AND peo.business_group_id = p_business_group_id
1996: AND job.business_group_id = p_business_group_id
1997: AND EXISTS (
1998: SELECT 'X'
1999: FROM HR_ORGANIZATION_INFORMATION HOI1,
2000: HR_ORGANIZATION_INFORMATION HOI2
2001: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2002: AND hoi1.org_information_context = 'Reporting Statuses'
2003: AND hoi1.organization_id = p_business_group_id

Line 2000: HR_ORGANIZATION_INFORMATION HOI2

1996: AND job.business_group_id = p_business_group_id
1997: AND EXISTS (
1998: SELECT 'X'
1999: FROM HR_ORGANIZATION_INFORMATION HOI1,
2000: HR_ORGANIZATION_INFORMATION HOI2
2001: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2002: AND hoi1.org_information_context = 'Reporting Statuses'
2003: AND hoi1.organization_id = p_business_group_id
2004: AND ass.employment_category = hoi2.org_information1

Line 2102: FROM hr_organization_information hoi1,

2098: AND peo.business_group_id = p_business_group_id
2099: AND job.business_group_id = p_business_group_id
2100: AND EXISTS (
2101: SELECT 'X'
2102: FROM hr_organization_information hoi1,
2103: hr_organization_information hoi2
2104: WHERE TO_CHAR(ass.assignment_status_type_id) = hoi1.org_information1
2105: AND hoi1.org_information_context = 'Reporting Statuses'
2106: AND hoi1.organization_id = p_business_group_id

Line 2103: hr_organization_information hoi2

2099: AND job.business_group_id = p_business_group_id
2100: AND EXISTS (
2101: SELECT 'X'
2102: FROM hr_organization_information hoi1,
2103: hr_organization_information hoi2
2104: WHERE TO_CHAR(ass.assignment_status_type_id) = hoi1.org_information1
2105: AND hoi1.org_information_context = 'Reporting Statuses'
2106: AND hoi1.organization_id = p_business_group_id
2107: AND ass.employment_category = hoi2.org_information1

Line 2206: FROM HR_ORGANIZATION_INFORMATION HOI1,

2202: AND peo.business_group_id = P_BUSINESS_GROUP_ID
2203: AND job.business_group_id = P_BUSINESS_GROUP_ID
2204: AND EXISTS (
2205: SELECT 'X'
2206: FROM HR_ORGANIZATION_INFORMATION HOI1,
2207: HR_ORGANIZATION_INFORMATION HOI2
2208: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2209: AND hoi1.org_information_context = 'Reporting Statuses'
2210: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 2207: HR_ORGANIZATION_INFORMATION HOI2

2203: AND job.business_group_id = P_BUSINESS_GROUP_ID
2204: AND EXISTS (
2205: SELECT 'X'
2206: FROM HR_ORGANIZATION_INFORMATION HOI1,
2207: HR_ORGANIZATION_INFORMATION HOI2
2208: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2209: AND hoi1.org_information_context = 'Reporting Statuses'
2210: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
2211: AND ass.employment_category = hoi2.org_information1

Line 2281: FROM HR_ORGANIZATION_INFORMATION HOI1,

2277: AND peo.business_group_id = P_BUSINESS_GROUP_ID
2278: AND job.business_group_id = P_BUSINESS_GROUP_ID
2279: AND EXISTS (
2280: SELECT 'X'
2281: FROM HR_ORGANIZATION_INFORMATION HOI1,
2282: HR_ORGANIZATION_INFORMATION HOI2
2283: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2284: AND hoi1.org_information_context = 'Reporting Statuses'
2285: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 2282: HR_ORGANIZATION_INFORMATION HOI2

2278: AND job.business_group_id = P_BUSINESS_GROUP_ID
2279: AND EXISTS (
2280: SELECT 'X'
2281: FROM HR_ORGANIZATION_INFORMATION HOI1,
2282: HR_ORGANIZATION_INFORMATION HOI2
2283: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
2284: AND hoi1.org_information_context = 'Reporting Statuses'
2285: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
2286: AND ass.employment_category = hoi2.org_information1

Line 2597: FROM hr_organization_information

2593: BEGIN--Local1
2594: l_organization_id := l_org_rec.par_ent_org_id;
2595: SELECT 'U', org_information_id
2596: INTO p_update, l_org_information_id
2597: FROM hr_organization_information
2598: WHERE org_information1 = p_report_year
2599: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive'
2600: AND organization_id = l_org_rec.par_ent_org_id;
2601:

Line 2645: FROM hr_organization_information

2641:
2642: BEGIN --Local2
2643: SELECT object_version_number
2644: INTO l_object_version_number
2645: FROM hr_organization_information
2646: WHERE org_information_id = l_org_information_id;
2647: END;--Local2
2648:
2649: --

Line 2750: FROM hr_organization_information

2746: BEGIN--Local6
2747:
2748: SELECT count(*)
2749: INTO l_eit_count
2750: FROM hr_organization_information
2751: WHERE organization_id = p_business_group_id
2752: AND org_information_context = 'EEO_Archive';
2753: EXCEPTION
2754: WHEN NO_DATA_FOUND THEN

Line 2764: FROM hr_organization_information

2760: IF l_eit_count > 4 THEN
2761: BEGIN--Local7
2762: SELECT MIN(org_information1)
2763: INTO l_min_year
2764: FROM hr_organization_information
2765: WHERE organization_id = p_business_group_id
2766: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
2767: END;--Local7
2768:

Line 2774: FROM hr_organization_information

2770: SELECT org_information_id,
2771: object_version_number
2772: INTO l_org_information_id
2773: ,l_object_version_number
2774: FROM hr_organization_information
2775: WHERE org_information1 = l_min_year
2776: AND org_information_context = 'EEO_Archive'
2777: AND organization_id = p_business_group_id;
2778: END;--Local8