APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 186: HR_ORGANIZATION_INFORMATION

182: 'U',
183: ORG_INFORMATION_ID
184: INTO P_UPDATE,L_ORG_INFORMATION_ID
185: FROM
186: HR_ORGANIZATION_INFORMATION
187: WHERE ORG_INFORMATION1 = P_REPORT_YEAR
188: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
189: EXCEPTION
190: WHEN NO_DATA_FOUND THEN

Line 221: HR_ORGANIZATION_INFORMATION

217: SELECT
218: OBJECT_VERSION_NUMBER
219: INTO L_OBJECT_VERSION_NUMBER
220: FROM
221: HR_ORGANIZATION_INFORMATION
222: WHERE ORG_INFORMATION_ID = L_ORG_INFORMATION_ID;
223: END;
224: /*SRW.MESSAGE('25'
225: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;

Line 284: HR_ORGANIZATION_INFORMATION

280: SELECT
281: count(*)
282: INTO L_EIT_COUNT
283: FROM
284: HR_ORGANIZATION_INFORMATION
285: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
286: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN

Line 299: HR_ORGANIZATION_INFORMATION

295: SELECT
296: MIN(ORG_INFORMATION1)
297: INTO L_MIN_YEAR
298: FROM
299: HR_ORGANIZATION_INFORMATION
300: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
301: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
302: END;
303: BEGIN

Line 309: HR_ORGANIZATION_INFORMATION

305: ORG_INFORMATION_ID,
306: OBJECT_VERSION_NUMBER
307: INTO L_ORG_INFORMATION_ID,L_OBJECT_VERSION_NUMBER
308: FROM
309: HR_ORGANIZATION_INFORMATION
310: WHERE ORG_INFORMATION1 = L_MIN_YEAR
311: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive'
312: AND ORGANIZATION_ID = C_PARENT_ORG_ID;
313: END;

Line 384: HR_ORGANIZATION_INFORMATION HOI1,

380: AND EXISTS (
381: SELECT
382: 'X'
383: FROM
384: HR_ORGANIZATION_INFORMATION HOI1,
385: HR_ORGANIZATION_INFORMATION HOI2
386: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
387: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
388: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 385: HR_ORGANIZATION_INFORMATION HOI2

381: SELECT
382: 'X'
383: FROM
384: HR_ORGANIZATION_INFORMATION HOI1,
385: HR_ORGANIZATION_INFORMATION HOI2
386: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
387: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
388: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
389: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1