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 437: HR_ALL_ORGANIZATION_UNITS

433: AND PAF.ORGANIZATION_ID IN (
434: SELECT
435: ORGANIZATION_ID
436: FROM
437: HR_ALL_ORGANIZATION_UNITS
438: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
439: GROUP BY
440: '1';
441: /* Commented for IPED Enh #7033011 Start

Line 606: HR_ALL_ORGANIZATION_UNITS

602: AND PAF.ORGANIZATION_ID IN (
603: SELECT
604: ORGANIZATION_ID
605: FROM
606: HR_ALL_ORGANIZATION_UNITS
607: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
608: Commented for IPED Enh #7033011 End */
609:
610: CURSOR GET_LINE2_COUNTS IS

Line 990: HR_ALL_ORGANIZATION_UNITS

986: AND PAF.ORGANIZATION_ID IN (
987: SELECT
988: ORGANIZATION_ID
989: FROM
990: HR_ALL_ORGANIZATION_UNITS
991: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
992: GROUP BY
993: '2';
994: /* Commented for IPED Enh #7033011 Start

Line 1159: HR_ALL_ORGANIZATION_UNITS

1155: AND PAF.ORGANIZATION_ID IN (
1156: SELECT
1157: ORGANIZATION_ID
1158: FROM
1159: HR_ALL_ORGANIZATION_UNITS
1160: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1161: Commented for IPED Enh #7033011 End*/
1162:
1163: CURSOR GET_LINE3_COUNTS IS

Line 1546: HR_ALL_ORGANIZATION_UNITS

1542: AND PAF.ORGANIZATION_ID IN (
1543: SELECT
1544: ORGANIZATION_ID
1545: FROM
1546: HR_ALL_ORGANIZATION_UNITS
1547: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1548: GROUP BY
1549: '3';
1550: /* Commented for IPED Enh #7033011 Start

Line 1718: HR_ALL_ORGANIZATION_UNITS

1714: AND PAF.ORGANIZATION_ID IN (
1715: SELECT
1716: ORGANIZATION_ID
1717: FROM
1718: HR_ALL_ORGANIZATION_UNITS
1719: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1720: Commented for IPED Enh #7033011 End*/
1721:
1722: CURSOR GET_LINE4_COUNTS IS

Line 2104: HR_ALL_ORGANIZATION_UNITS

2100: AND PAF.ORGANIZATION_ID in (
2101: SELECT
2102: ORGANIZATION_ID
2103: FROM
2104: HR_ALL_ORGANIZATION_UNITS
2105: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2106: GROUP BY
2107: HL.LOOKUP_CODE;
2108: /* Commented for IPED Enh #7033011 Start

Line 2267: HR_ALL_ORGANIZATION_UNITS

2263: AND PAF.ORGANIZATION_ID in (
2264: SELECT
2265: ORGANIZATION_ID
2266: FROM
2267: HR_ALL_ORGANIZATION_UNITS
2268: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2269: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
2270: Commented for IPED Enh #7033011 End*/
2271: BEGIN