APPS.PQH_PQIPED5_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 411: HR_ALL_ORGANIZATION_UNITS ORG

407: AND ASS.ORGANIZATION_ID in (
408: SELECT
409: ORG.ORGANIZATION_ID
410: FROM
411: HR_ALL_ORGANIZATION_UNITS ORG
412: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
413: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )
414: GROUP BY
415: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 616: HR_ALL_ORGANIZATION_UNITS ORG

612: AND ASS.ORGANIZATION_ID in (
613: SELECT
614: ORG.ORGANIZATION_ID
615: FROM
616: HR_ALL_ORGANIZATION_UNITS ORG
617: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
618: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )
619: AND PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
620: ,CP_FR

Line 849: HR_ALL_ORGANIZATION_UNITS ORG

845: AND ASS.ORGANIZATION_ID in (
846: SELECT
847: ORG.ORGANIZATION_ID
848: FROM
849: HR_ALL_ORGANIZATION_UNITS ORG
850: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
851: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' );
852: CURSOR GET_TMR_LINE2_COUNTS IS
853: SELECT

Line 1045: HR_ALL_ORGANIZATION_UNITS ORG

1041: AND ASS.ORGANIZATION_ID in (
1042: SELECT
1043: ORG.ORGANIZATION_ID
1044: FROM
1045: HR_ALL_ORGANIZATION_UNITS ORG
1046: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
1047: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' );
1048: BEGIN
1049: -- HR_STANDARD.EVENT('BEFORE REPORT');