APPS.PQH_PQIPED5_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 633: HR_ALL_ORGANIZATION_UNITS ORG

629: AND ASS.ORGANIZATION_ID in (
630: SELECT
631: ORG.ORGANIZATION_ID
632: FROM
633: HR_ALL_ORGANIZATION_UNITS ORG
634: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
635: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )
636: GROUP BY
637: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 840: HR_ALL_ORGANIZATION_UNITS ORG

836: AND ASS.ORGANIZATION_ID in (
837: SELECT
838: ORG.ORGANIZATION_ID
839: FROM
840: HR_ALL_ORGANIZATION_UNITS ORG
841: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
842: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )
843: AND PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
844: ,CP_FR

Line 1267: HR_ALL_ORGANIZATION_UNITS ORG

1263: AND ASS.ORGANIZATION_ID in (
1264: SELECT
1265: ORG.ORGANIZATION_ID
1266: FROM
1267: HR_ALL_ORGANIZATION_UNITS ORG
1268: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
1269: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' );
1270:
1271: /* Commeting for the bug#7033011

Line 1466: HR_ALL_ORGANIZATION_UNITS ORG

1462: AND ASS.ORGANIZATION_ID in (
1463: SELECT
1464: ORG.ORGANIZATION_ID
1465: FROM
1466: HR_ALL_ORGANIZATION_UNITS ORG
1467: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
1468: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' ); */
1469:
1470: BEGIN