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_PERUSEO1_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 220: HR_ORGANIZATION_INFORMATION

216: SELECT
217: null
218: INTO L_DUMMY
219: FROM
220: HR_ORGANIZATION_INFORMATION
221: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
222: AND ORG_INFORMATION_CONTEXT = 'EEO_Spec';
223: EXCEPTION
224: WHEN NO_DATA_FOUND THEN

Line 444: HR_ORGANIZATION_INFORMATION

440: ORG_INFORMATION9,
441: ORG_INFORMATION11,
442: ORG_INFORMATION12
443: FROM
444: HR_ORGANIZATION_INFORMATION
445: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
446: AND ORG_INFORMATION_CONTEXT = 'VETS_EEO_Dup';
447: L_DEFAULT C_DEFAULTS%ROWTYPE;
448: BEGIN

Line 527: HR_ORGANIZATION_INFORMATION HOI1

523: AND EXISTS (
524: SELECT
525: 'X'
526: FROM
527: HR_ORGANIZATION_INFORMATION HOI1
528: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
529: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
530: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
531: )

Line 535: FROM HR_ORGANIZATION_INFORMATION HOI2

531: )
532: AND EXISTS (
533: SELECT
534: 'X'
535: FROM HR_ORGANIZATION_INFORMATION HOI2
536: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
537: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
538: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
539: )

Line 546: HR_ORGANIZATION_INFORMATION HOI1,

542: AND EXISTS (
543: SELECT
544: 'X'
545: FROM
546: HR_ORGANIZATION_INFORMATION HOI1,
547: HR_ORGANIZATION_INFORMATION HOI2
548: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
549: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
550: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 547: HR_ORGANIZATION_INFORMATION HOI2

543: SELECT
544: 'X'
545: FROM
546: HR_ORGANIZATION_INFORMATION HOI1,
547: HR_ORGANIZATION_INFORMATION HOI2
548: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
549: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
550: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
551: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 787: HR_ORGANIZATION_INFORMATION HOI1

783: AND EXISTS (
784: SELECT
785: 'X'
786: FROM
787: HR_ORGANIZATION_INFORMATION HOI1
788: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
789: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
790: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
791: )

Line 795: FROM HR_ORGANIZATION_INFORMATION HOI2

791: )
792: AND EXISTS (
793: SELECT
794: 'X'
795: FROM HR_ORGANIZATION_INFORMATION HOI2
796: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
797: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
798: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
799: )

Line 806: HR_ORGANIZATION_INFORMATION HOI1,

802: AND EXISTS (
803: SELECT
804: 'X'
805: FROM
806: HR_ORGANIZATION_INFORMATION HOI1,
807: HR_ORGANIZATION_INFORMATION HOI2
808: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
809: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
810: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 807: HR_ORGANIZATION_INFORMATION HOI2

803: SELECT
804: 'X'
805: FROM
806: HR_ORGANIZATION_INFORMATION HOI1,
807: HR_ORGANIZATION_INFORMATION HOI2
808: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
809: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
810: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
811: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 969: HR_ORGANIZATION_INFORMATION HOI1

965: AND EXISTS (
966: SELECT
967: 'X'
968: FROM
969: HR_ORGANIZATION_INFORMATION HOI1
970: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
971: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
972: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
973: )

Line 977: FROM HR_ORGANIZATION_INFORMATION HOI2

973: )
974: AND EXISTS (
975: SELECT
976: 'X'
977: FROM HR_ORGANIZATION_INFORMATION HOI2
978: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
979: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
980: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
981: )

Line 988: HR_ORGANIZATION_INFORMATION HOI1,

984: AND EXISTS (
985: SELECT
986: 'X'
987: FROM
988: HR_ORGANIZATION_INFORMATION HOI1,
989: HR_ORGANIZATION_INFORMATION HOI2
990: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
991: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
992: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 989: HR_ORGANIZATION_INFORMATION HOI2

985: SELECT
986: 'X'
987: FROM
988: HR_ORGANIZATION_INFORMATION HOI1,
989: HR_ORGANIZATION_INFORMATION HOI2
990: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
991: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
992: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
993: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1

Line 1291: HR_ORGANIZATION_INFORMATION HOI1

1287: AND EXISTS (
1288: SELECT
1289: 'X'
1290: FROM
1291: HR_ORGANIZATION_INFORMATION HOI1
1292: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1293: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
1294: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
1295: )

Line 1299: FROM HR_ORGANIZATION_INFORMATION HOI2

1295: )
1296: AND EXISTS (
1297: SELECT
1298: 'X'
1299: FROM HR_ORGANIZATION_INFORMATION HOI2
1300: where ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1
1301: AND HOI2.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
1302: AND HOI2.ORG_INFORMATION_CONTEXT = 'Reporting Categories'
1303: )

Line 1310: HR_ORGANIZATION_INFORMATION HOI1,

1306: AND EXISTS (
1307: SELECT
1308: 'X'
1309: FROM
1310: HR_ORGANIZATION_INFORMATION HOI1,
1311: HR_ORGANIZATION_INFORMATION HOI2
1312: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1313: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
1314: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID

Line 1311: HR_ORGANIZATION_INFORMATION HOI2

1307: SELECT
1308: 'X'
1309: FROM
1310: HR_ORGANIZATION_INFORMATION HOI1,
1311: HR_ORGANIZATION_INFORMATION HOI2
1312: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1313: AND HOI1.ORG_INFORMATION_CONTEXT = 'Reporting Statuses'
1314: AND HOI1.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
1315: AND ASS.EMPLOYMENT_CATEGORY = HOI2.ORG_INFORMATION1