APPS.PQH_PQIPED8_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 456: HR_ALL_ORGANIZATION_UNITS

452: AND PAF.ORGANIZATION_ID IN (
453: SELECT
454: ORGANIZATION_ID
455: FROM
456: HR_ALL_ORGANIZATION_UNITS
457: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
458: GROUP BY
459: '01',
460: HLA.LOOKUP_CODE;

Line 653: HR_ALL_ORGANIZATION_UNITS

649: AND PAF.ORGANIZATION_ID IN (
650: SELECT
651: ORGANIZATION_ID
652: FROM
653: HR_ALL_ORGANIZATION_UNITS
654: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
655: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
656: Commented for IPED Enh #7033011 End */
657:

Line 1067: HR_ALL_ORGANIZATION_UNITS

1063: AND PAF.ORGANIZATION_ID IN (
1064: SELECT
1065: ORGANIZATION_ID
1066: FROM
1067: HR_ALL_ORGANIZATION_UNITS
1068: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1069: GROUP BY
1070: '01',
1071: '01';

Line 1264: HR_ALL_ORGANIZATION_UNITS

1260: AND PAF.ORGANIZATION_ID IN (
1261: SELECT
1262: ORGANIZATION_ID
1263: FROM
1264: HR_ALL_ORGANIZATION_UNITS
1265: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1266: Commented for IPED Enh #7033011 End */
1267:
1268: CURSOR GET_LINE3_COUNTS IS

Line 1676: HR_ALL_ORGANIZATION_UNITS

1672: AND PAF.ORGANIZATION_ID IN (
1673: SELECT
1674: ORGANIZATION_ID
1675: FROM
1676: HR_ALL_ORGANIZATION_UNITS
1677: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1678: GROUP BY
1679: '02',
1680: HLA.LOOKUP_CODE;

Line 1873: HR_ALL_ORGANIZATION_UNITS

1869: AND PAF.ORGANIZATION_ID IN (
1870: SELECT
1871: ORGANIZATION_ID
1872: FROM
1873: HR_ALL_ORGANIZATION_UNITS
1874: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1875: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
1876: Commented for IPED Enh #7033011 End */
1877:

Line 2286: HR_ALL_ORGANIZATION_UNITS

2282: AND PAF.ORGANIZATION_ID IN (
2283: SELECT
2284: ORGANIZATION_ID
2285: FROM
2286: HR_ALL_ORGANIZATION_UNITS
2287: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2288: GROUP BY
2289: '02',
2290: '01';

Line 2484: HR_ALL_ORGANIZATION_UNITS

2480: AND PAF.ORGANIZATION_ID IN (
2481: SELECT
2482: ORGANIZATION_ID
2483: FROM
2484: HR_ALL_ORGANIZATION_UNITS
2485: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
2486: Commented for IPED Enh #7033011 End */
2487:
2488: CURSOR GET_LINE5_COUNTS IS

Line 2899: HR_ALL_ORGANIZATION_UNITS

2895: AND PAF.ORGANIZATION_ID IN (
2896: SELECT
2897: ORGANIZATION_ID
2898: FROM
2899: HR_ALL_ORGANIZATION_UNITS
2900: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
2901: GROUP BY
2902: '03',
2903: HLA.LOOKUP_CODE;

Line 3100: HR_ALL_ORGANIZATION_UNITS

3096: AND PAF.ORGANIZATION_ID IN (
3097: SELECT
3098: ORGANIZATION_ID
3099: FROM
3100: HR_ALL_ORGANIZATION_UNITS
3101: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
3102: AND HLA.LOOKUP_CODE = C_LOOKUP_CODE;
3103: Commented for IPED Enh #7033011 End */
3104:

Line 3516: HR_ALL_ORGANIZATION_UNITS

3512: AND PAF.ORGANIZATION_ID IN (
3513: SELECT
3514: ORGANIZATION_ID
3515: FROM
3516: HR_ALL_ORGANIZATION_UNITS
3517: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
3518: GROUP BY
3519: '03',
3520: '01';

Line 3716: HR_ALL_ORGANIZATION_UNITS

3712: AND PAF.ORGANIZATION_ID IN (
3713: SELECT
3714: ORGANIZATION_ID
3715: FROM
3716: HR_ALL_ORGANIZATION_UNITS
3717: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
3718: Commented for IPED Enh #7033011 End */
3719: BEGIN
3720: -- HR_STANDARD.EVENT('BEFORE REPORT');