APPS.PQH_PQIPED10_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 325: HR_ALL_ORGANIZATION_UNITS

321: AND ASS.ORGANIZATION_ID in (
322: SELECT
323: ORGANIZATION_ID
324: FROM
325: HR_ALL_ORGANIZATION_UNITS
326: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
327: GROUP BY
328: HL.LOOKUP_CODE;
329: CURSOR GET_LINE1_TMRACES_COUNTS(C_LOOKUP_CODE IN VARCHAR2) IS

Line 503: HR_ALL_ORGANIZATION_UNITS

499: AND ASS.ORGANIZATION_ID in (
500: SELECT
501: ORGANIZATION_ID
502: FROM
503: HR_ALL_ORGANIZATION_UNITS
504: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
505: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
506: CURSOR GET_LINE2_COUNTS IS
507: SELECT

Line 710: HR_ALL_ORGANIZATION_UNITS

706: AND ASS.ORGANIZATION_ID in (
707: SELECT
708: ORGANIZATION_ID
709: FROM
710: HR_ALL_ORGANIZATION_UNITS
711: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
712: CURSOR GET_TMR_LINE2_COUNTS IS
713: SELECT
714: COUNT(DECODE(PEI.PEI_INFORMATION5

Line 886: HR_ALL_ORGANIZATION_UNITS

882: AND ASS.ORGANIZATION_ID in (
883: SELECT
884: ORGANIZATION_ID
885: FROM
886: HR_ALL_ORGANIZATION_UNITS
887: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
888: begin
889: --hr_standard.event('BEFORE REPORT');
890: