APPS.PQH_PQIPED8_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 261: HR_ALL_ORGANIZATION_UNITS

257: AND PAF.ORGANIZATION_ID IN (
258: SELECT
259: ORGANIZATION_ID
260: FROM
261: HR_ALL_ORGANIZATION_UNITS
262: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
263: GROUP BY
264: '01',
265: HLA.LOOKUP_CODE;

Line 457: HR_ALL_ORGANIZATION_UNITS

453: AND PAF.ORGANIZATION_ID IN (
454: SELECT
455: ORGANIZATION_ID
456: FROM
457: HR_ALL_ORGANIZATION_UNITS
458: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
459: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
460: CURSOR GET_LINE2_COUNTS IS
461: SELECT

Line 681: HR_ALL_ORGANIZATION_UNITS

677: AND PAF.ORGANIZATION_ID IN (
678: SELECT
679: ORGANIZATION_ID
680: FROM
681: HR_ALL_ORGANIZATION_UNITS
682: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
683: GROUP BY
684: '01',
685: '01';

Line 877: HR_ALL_ORGANIZATION_UNITS

873: AND PAF.ORGANIZATION_ID IN (
874: SELECT
875: ORGANIZATION_ID
876: FROM
877: HR_ALL_ORGANIZATION_UNITS
878: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
879: CURSOR GET_LINE3_COUNTS IS
880: SELECT
881: '02' TENINFO,

Line 1100: HR_ALL_ORGANIZATION_UNITS

1096: AND PAF.ORGANIZATION_ID IN (
1097: SELECT
1098: ORGANIZATION_ID
1099: FROM
1100: HR_ALL_ORGANIZATION_UNITS
1101: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1102: GROUP BY
1103: '02',
1104: HLA.LOOKUP_CODE;

Line 1296: HR_ALL_ORGANIZATION_UNITS

1292: AND PAF.ORGANIZATION_ID IN (
1293: SELECT
1294: ORGANIZATION_ID
1295: FROM
1296: HR_ALL_ORGANIZATION_UNITS
1297: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1298: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
1299: CURSOR GET_LINE4_COUNTS IS
1300: SELECT

Line 1520: HR_ALL_ORGANIZATION_UNITS

1516: AND PAF.ORGANIZATION_ID IN (
1517: SELECT
1518: ORGANIZATION_ID
1519: FROM
1520: HR_ALL_ORGANIZATION_UNITS
1521: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1522: GROUP BY
1523: '02',
1524: '01';

Line 1716: HR_ALL_ORGANIZATION_UNITS

1712: AND PAF.ORGANIZATION_ID IN (
1713: SELECT
1714: ORGANIZATION_ID
1715: FROM
1716: HR_ALL_ORGANIZATION_UNITS
1717: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1718: CURSOR GET_LINE5_COUNTS IS
1719: SELECT
1720: '03' TENINFO,

Line 1942: HR_ALL_ORGANIZATION_UNITS

1938: AND PAF.ORGANIZATION_ID IN (
1939: SELECT
1940: ORGANIZATION_ID
1941: FROM
1942: HR_ALL_ORGANIZATION_UNITS
1943: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1944: GROUP BY
1945: '03',
1946: HLA.LOOKUP_CODE;

Line 2141: HR_ALL_ORGANIZATION_UNITS

2137: AND PAF.ORGANIZATION_ID IN (
2138: SELECT
2139: ORGANIZATION_ID
2140: FROM
2141: HR_ALL_ORGANIZATION_UNITS
2142: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2143: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
2144: CURSOR GET_LINE6_COUNTS IS
2145: SELECT

Line 2368: HR_ALL_ORGANIZATION_UNITS

2364: AND PAF.ORGANIZATION_ID IN (
2365: SELECT
2366: ORGANIZATION_ID
2367: FROM
2368: HR_ALL_ORGANIZATION_UNITS
2369: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2370: GROUP BY
2371: '03',
2372: '01';

Line 2567: HR_ALL_ORGANIZATION_UNITS

2563: AND PAF.ORGANIZATION_ID IN (
2564: SELECT
2565: ORGANIZATION_ID
2566: FROM
2567: HR_ALL_ORGANIZATION_UNITS
2568: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
2569: BEGIN
2570: -- HR_STANDARD.EVENT('BEFORE REPORT');
2571: CP_REPORT_DATE := to_char(P_REPORT_DATE,'DD-MON-YYYY');