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_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 203: HR_ORGANIZATION_INFORMATION HOI1

199: AND EXISTS (
200: SELECT
201: 'X'
202: FROM
203: HR_ORGANIZATION_INFORMATION HOI1
204: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
205: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
206: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
207: )

Line 211: FROM HR_ORGANIZATION_INFORMATION HOI2

207: )
208: AND EXISTS (
209: SELECT
210: 'X'
211: FROM HR_ORGANIZATION_INFORMATION HOI2
212: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
213: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
214: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
215: )

Line 222: HR_ORGANIZATION_INFORMATION HOI1,

218: AND EXISTS (
219: SELECT
220: 'X'
221: FROM
222: HR_ORGANIZATION_INFORMATION HOI1,
223: HR_ORGANIZATION_INFORMATION HOI2
224: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
225: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
226: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 223: HR_ORGANIZATION_INFORMATION HOI2

219: SELECT
220: 'X'
221: FROM
222: HR_ORGANIZATION_INFORMATION HOI1,
223: HR_ORGANIZATION_INFORMATION HOI2
224: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
225: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
226: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
227: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 345: HR_ORGANIZATION_INFORMATION HOI1

341: AND EXISTS (
342: SELECT
343: 'X'
344: FROM
345: HR_ORGANIZATION_INFORMATION HOI1
346: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
347: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
348: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
349: )

Line 353: FROM HR_ORGANIZATION_INFORMATION HOI2

349: )
350: AND EXISTS (
351: SELECT
352: 'X'
353: FROM HR_ORGANIZATION_INFORMATION HOI2
354: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
355: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
356: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
357: )

Line 364: HR_ORGANIZATION_INFORMATION HOI1,

360: AND EXISTS (
361: SELECT
362: 'X'
363: FROM
364: HR_ORGANIZATION_INFORMATION HOI1,
365: HR_ORGANIZATION_INFORMATION HOI2
366: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
367: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
368: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 365: HR_ORGANIZATION_INFORMATION HOI2

361: SELECT
362: 'X'
363: FROM
364: HR_ORGANIZATION_INFORMATION HOI1,
365: HR_ORGANIZATION_INFORMATION HOI2
366: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
367: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
368: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
369: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 434: HR_ORGANIZATION_INFORMATION HOI1

430: AND EXISTS (
431: SELECT
432: 'X'
433: FROM
434: HR_ORGANIZATION_INFORMATION HOI1
435: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
436: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
437: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
438: )

Line 442: FROM HR_ORGANIZATION_INFORMATION HOI2

438: )
439: AND EXISTS (
440: SELECT
441: 'X'
442: FROM HR_ORGANIZATION_INFORMATION HOI2
443: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
444: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
445: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
446: )

Line 453: HR_ORGANIZATION_INFORMATION HOI1,

449: AND EXISTS (
450: SELECT
451: 'X'
452: FROM
453: HR_ORGANIZATION_INFORMATION HOI1,
454: HR_ORGANIZATION_INFORMATION HOI2
455: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
456: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
457: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 454: HR_ORGANIZATION_INFORMATION HOI2

450: SELECT
451: 'X'
452: FROM
453: HR_ORGANIZATION_INFORMATION HOI1,
454: HR_ORGANIZATION_INFORMATION HOI2
455: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
456: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
457: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
458: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1