APPS.PER_PERUSEO1_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 79: HR_ORGANIZATION_INFORMATION

75: SELECT
76: null
77: INTO L_DUMMY
78: FROM
79: HR_ORGANIZATION_INFORMATION
80: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
81: AND ORG_INFORMATION_CONTEXT = 'EEO_Spec';
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN

Line 281: HR_ORGANIZATION_INFORMATION

277: ORG_INFORMATION9,
278: ORG_INFORMATION11,
279: ORG_INFORMATION12
280: FROM
281: HR_ORGANIZATION_INFORMATION
282: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
283: AND ORG_INFORMATION_CONTEXT = 'VETS_EEO_Dup';
284: L_DEFAULT C_DEFAULTS%ROWTYPE;
285: BEGIN

Line 356: HR_ORGANIZATION_INFORMATION HOI1,

352: AND EXISTS (
353: SELECT
354: 'X'
355: FROM
356: HR_ORGANIZATION_INFORMATION HOI1,
357: HR_ORGANIZATION_INFORMATION HOI2
358: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
359: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
360: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 357: HR_ORGANIZATION_INFORMATION HOI2

353: SELECT
354: 'X'
355: FROM
356: HR_ORGANIZATION_INFORMATION HOI1,
357: HR_ORGANIZATION_INFORMATION HOI2
358: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
359: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
360: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
361: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 530: HR_ORGANIZATION_INFORMATION HOI1,

526: AND EXISTS (
527: SELECT
528: 'X'
529: FROM
530: HR_ORGANIZATION_INFORMATION HOI1,
531: HR_ORGANIZATION_INFORMATION HOI2
532: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
533: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
534: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 531: HR_ORGANIZATION_INFORMATION HOI2

527: SELECT
528: 'X'
529: FROM
530: HR_ORGANIZATION_INFORMATION HOI1,
531: HR_ORGANIZATION_INFORMATION HOI2
532: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
533: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
534: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
535: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 635: HR_ORGANIZATION_INFORMATION HOI1,

631: AND EXISTS (
632: SELECT
633: 'X'
634: FROM
635: HR_ORGANIZATION_INFORMATION HOI1,
636: HR_ORGANIZATION_INFORMATION HOI2
637: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
638: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
639: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 636: HR_ORGANIZATION_INFORMATION HOI2

632: SELECT
633: 'X'
634: FROM
635: HR_ORGANIZATION_INFORMATION HOI1,
636: HR_ORGANIZATION_INFORMATION HOI2
637: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
638: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
639: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
640: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 895: HR_ORGANIZATION_INFORMATION HOI1,

891: AND EXISTS (
892: SELECT
893: 'X'
894: FROM
895: HR_ORGANIZATION_INFORMATION HOI1,
896: HR_ORGANIZATION_INFORMATION HOI2
897: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
898: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
899: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 896: HR_ORGANIZATION_INFORMATION HOI2

892: SELECT
893: 'X'
894: FROM
895: HR_ORGANIZATION_INFORMATION HOI1,
896: HR_ORGANIZATION_INFORMATION HOI2
897: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
898: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
899: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
900: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1