APPS.PER_PERUSE1L_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 17: HR_ORGANIZATION_INFORMATION

13: ORG_INFORMATION9,
14: ORG_INFORMATION11,
15: ORG_INFORMATION12
16: FROM
17: HR_ORGANIZATION_INFORMATION
18: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
19: AND ORG_INFORMATION_CONTEXT = 'VETS_EEO_Dup';
20: L_DEFAULT C_DEFAULTS%ROWTYPE;
21: L_BUFFER VARCHAR2(1000);

Line 190: HR_ORGANIZATION_INFORMATION HOI1,

186: AND EXISTS (
187: SELECT
188: 'X'
189: FROM
190: HR_ORGANIZATION_INFORMATION HOI1,
191: HR_ORGANIZATION_INFORMATION HOI2
192: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
193: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
194: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 191: HR_ORGANIZATION_INFORMATION HOI2

187: SELECT
188: 'X'
189: FROM
190: HR_ORGANIZATION_INFORMATION HOI1,
191: HR_ORGANIZATION_INFORMATION HOI2
192: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
193: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
194: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
195: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 275: HR_ORGANIZATION_INFORMATION HOI1,

271: AND EXISTS (
272: SELECT
273: 'X'
274: FROM
275: HR_ORGANIZATION_INFORMATION HOI1,
276: HR_ORGANIZATION_INFORMATION HOI2
277: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
278: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
279: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 276: HR_ORGANIZATION_INFORMATION HOI2

272: SELECT
273: 'X'
274: FROM
275: HR_ORGANIZATION_INFORMATION HOI1,
276: HR_ORGANIZATION_INFORMATION HOI2
277: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
278: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
279: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
280: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 316: HR_ORGANIZATION_INFORMATION HOI1,

312: AND EXISTS (
313: SELECT
314: 'X'
315: FROM
316: HR_ORGANIZATION_INFORMATION HOI1,
317: HR_ORGANIZATION_INFORMATION HOI2
318: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
319: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
320: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 317: HR_ORGANIZATION_INFORMATION HOI2

313: SELECT
314: 'X'
315: FROM
316: HR_ORGANIZATION_INFORMATION HOI1,
317: HR_ORGANIZATION_INFORMATION HOI2
318: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
319: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
320: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
321: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1