APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 190: HR_ORGANIZATION_INFORMATION

186: 'U',
187: ORG_INFORMATION_ID
188: INTO P_UPDATE,L_ORG_INFORMATION_ID
189: FROM
190: HR_ORGANIZATION_INFORMATION
191: WHERE ORG_INFORMATION1 = P_REPORT_YEAR
192: AND ORGANIZATION_ID = C_PARENT_ORG_ID -- Added for bug#12575094
193: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
194: EXCEPTION

Line 226: HR_ORGANIZATION_INFORMATION

222: SELECT
223: OBJECT_VERSION_NUMBER
224: INTO L_OBJECT_VERSION_NUMBER
225: FROM
226: HR_ORGANIZATION_INFORMATION
227: WHERE ORG_INFORMATION_ID = L_ORG_INFORMATION_ID;
228: END;
229: /*SRW.MESSAGE('25'
230: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;

Line 289: HR_ORGANIZATION_INFORMATION

285: SELECT
286: count(*)
287: INTO L_EIT_COUNT
288: FROM
289: HR_ORGANIZATION_INFORMATION
290: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
291: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
292: EXCEPTION
293: WHEN NO_DATA_FOUND THEN

Line 304: HR_ORGANIZATION_INFORMATION

300: SELECT
301: MIN(ORG_INFORMATION1)
302: INTO L_MIN_YEAR
303: FROM
304: HR_ORGANIZATION_INFORMATION
305: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
306: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive';
307: END;
308: BEGIN

Line 314: HR_ORGANIZATION_INFORMATION

310: ORG_INFORMATION_ID,
311: OBJECT_VERSION_NUMBER
312: INTO L_ORG_INFORMATION_ID,L_OBJECT_VERSION_NUMBER
313: FROM
314: HR_ORGANIZATION_INFORMATION
315: WHERE ORG_INFORMATION1 = L_MIN_YEAR
316: AND ORG_INFORMATION_CONTEXT = 'EEO_Archive'
317: AND ORGANIZATION_ID = C_PARENT_ORG_ID;
318: END;

Line 398: HR_ORGANIZATION_INFORMATION HOI1

394: AND EXISTS (
395: SELECT
396: 'X'
397: FROM
398: HR_ORGANIZATION_INFORMATION HOI1
399: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
400: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
401: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
402: )

Line 406: FROM HR_ORGANIZATION_INFORMATION HOI2

402: )
403: AND EXISTS (
404: SELECT
405: 'X'
406: FROM HR_ORGANIZATION_INFORMATION HOI2
407: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
408: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
409: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
410: )

Line 417: HR_ORGANIZATION_INFORMATION HOI1,

413: AND EXISTS (
414: SELECT
415: 'X'
416: FROM
417: HR_ORGANIZATION_INFORMATION HOI1,
418: HR_ORGANIZATION_INFORMATION HOI2
419: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
420: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
421: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 418: HR_ORGANIZATION_INFORMATION HOI2

414: SELECT
415: 'X'
416: FROM
417: HR_ORGANIZATION_INFORMATION HOI1,
418: HR_ORGANIZATION_INFORMATION HOI2
419: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
420: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
421: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
422: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1