DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PQH_SALARY_CLASS_INTERVALS_PKG

Line 217: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

213: ,9
214: ,'02'
215: ,11
216: ,'03') SC,
217: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
218: ,CP_FR
219: ,CP_FT
220: ,CP_PR
221: ,CP_PT)

Line 637: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

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
640: ,CP_PR
641: ,CP_PT)

Line 843: AND PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

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
847: ,CP_PT)