DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PQH_SALARY_CLASS_INTERVALS_PKG

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

178: ,9
179: ,'02'
180: ,11
181: ,'03') SC,
182: PQH_SALARY_CLASS_INTERVALS_PKG.GET_SALARY_INTERVAL(PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
183: ,CP_FR
184: ,CP_FT
185: ,CP_PR
186: ,CP_PT)

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

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
416: ,CP_FR
417: ,CP_FT
418: ,CP_PR
419: ,CP_PT)

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

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
621: ,CP_FT
622: ,CP_PR
623: ,CP_PT)