APPS.PQH_PQIPED5_XMLP_PKG dependencies on PQH_INST_TYPE_PKG

Line 635: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )

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
638: ,CP_FR
639: ,CP_FT

Line 842: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' )

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
845: ,CP_FT
846: ,CP_PR

Line 1269: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' );

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
1272:
1273: CURSOR GET_TMR_LINE2_COUNTS IS

Line 1468: AND PQH_INST_TYPE_PKG.GET_INST_TYPE(ORG.ORGANIZATION_ID) = 'NON-MED' ); */

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
1471: -- HR_STANDARD.EVENT('BEFORE REPORT');
1472: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID