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.PQH_PQIPED9_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 244: HR_ALL_ORGANIZATION_UNITS

240: AND PAF.ORGANIZATION_ID IN (
241: SELECT
242: ORGANIZATION_ID
243: FROM
244: HR_ALL_ORGANIZATION_UNITS
245: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
246: GROUP BY
247: '1';
248: CURSOR GET_LINE1_TMRACES_COUNTS IS

Line 412: HR_ALL_ORGANIZATION_UNITS

408: AND PAF.ORGANIZATION_ID IN (
409: SELECT
410: ORGANIZATION_ID
411: FROM
412: HR_ALL_ORGANIZATION_UNITS
413: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
414: CURSOR GET_LINE2_COUNTS IS
415: SELECT
416: '2' JCODE,

Line 607: HR_ALL_ORGANIZATION_UNITS

603: AND PAF.ORGANIZATION_ID IN (
604: SELECT
605: ORGANIZATION_ID
606: FROM
607: HR_ALL_ORGANIZATION_UNITS
608: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
609: GROUP BY
610: '2';
611: CURSOR GET_TMR_LINE2_COUNTS IS

Line 775: HR_ALL_ORGANIZATION_UNITS

771: AND PAF.ORGANIZATION_ID IN (
772: SELECT
773: ORGANIZATION_ID
774: FROM
775: HR_ALL_ORGANIZATION_UNITS
776: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
777: CURSOR GET_LINE3_COUNTS IS
778: SELECT
779: '3' JCODE,

Line 973: HR_ALL_ORGANIZATION_UNITS

969: AND PAF.ORGANIZATION_ID IN (
970: SELECT
971: ORGANIZATION_ID
972: FROM
973: HR_ALL_ORGANIZATION_UNITS
974: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
975: GROUP BY
976: '3';
977: CURSOR GET_LINE3_TMR_COUNTS IS

Line 1144: HR_ALL_ORGANIZATION_UNITS

1140: AND PAF.ORGANIZATION_ID IN (
1141: SELECT
1142: ORGANIZATION_ID
1143: FROM
1144: HR_ALL_ORGANIZATION_UNITS
1145: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1146: CURSOR GET_LINE4_COUNTS IS
1147: SELECT
1148: HL.LOOKUP_CODE JCODE,

Line 1341: HR_ALL_ORGANIZATION_UNITS

1337: AND PAF.ORGANIZATION_ID in (
1338: SELECT
1339: ORGANIZATION_ID
1340: FROM
1341: HR_ALL_ORGANIZATION_UNITS
1342: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1343: GROUP BY
1344: HL.LOOKUP_CODE;
1345: CURSOR GET_LINE4_TMR_COUNTS(C_LOOKUP_CODE IN VARCHAR2) IS

Line 1503: HR_ALL_ORGANIZATION_UNITS

1499: AND PAF.ORGANIZATION_ID in (
1500: SELECT
1501: ORGANIZATION_ID
1502: FROM
1503: HR_ALL_ORGANIZATION_UNITS
1504: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1505: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
1506: BEGIN
1507: --HR_STANDARD.EVENT('BEFORE REPORT');