[Home] [Help]
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)
357: PER_SHARED_TYPES PST1
358: WHERE PEO.PERSON_ID = ASS.PERSON_ID
359: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
360: AND PCO.PERSON_ID = PEO.PERSON_ID
361: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
362: ,CP_FR
363: ,CP_FT
364: ,CP_PR
365: ,CP_PT) IN ( 'FR' )
393: AND PST.BUSINESS_GROUP_ID is null
394: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
395: AND NVL(PST1.INFORMATION1
396: ,PST.INFORMATION1) = 'Y'
397: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
398: ,PCO.DURATION_UNITS
399: ,PCO.BUSINESS_GROUP_ID
400: ,P_REPORT_DATE) BETWEEN C_DURATION1
401: AND C_DURATION2
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)
562: FROM
563: PER_PEOPLE_EXTRA_INFO PEI3
564: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
565: AND PCO.PERSON_ID = PEO.PERSON_ID
566: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
567: ,CP_FR
568: ,CP_FT
569: ,CP_PR
570: ,CP_PT) IN ( 'FR' )
598: AND PST.BUSINESS_GROUP_ID is null
599: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
600: AND NVL(PST1.INFORMATION1
601: ,PST.INFORMATION1) = 'Y'
602: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
603: ,PCO.DURATION_UNITS
604: ,PCO.BUSINESS_GROUP_ID
605: ,P_REPORT_DATE) BETWEEN C_DURATION1
606: AND C_DURATION2
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)
796: PER_SHARED_TYPES PST1
797: WHERE PEO.PERSON_ID = ASS.PERSON_ID
798: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
799: AND PCO.PERSON_ID = PEO.PERSON_ID
800: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
801: ,CP_FR
802: ,CP_FT
803: ,CP_PR
804: ,CP_PT) IN ( 'FR' )
832: AND PST.BUSINESS_GROUP_ID is null
833: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
834: AND NVL(PST1.INFORMATION1
835: ,PST.INFORMATION1) = 'Y'
836: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
837: ,PCO.DURATION_UNITS
838: ,PCO.BUSINESS_GROUP_ID
839: ,P_REPORT_DATE) < 9
840: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
992: FROM
993: PER_PEOPLE_EXTRA_INFO PEI3
994: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
995: AND PCO.PERSON_ID = PEO.PERSON_ID
996: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
997: ,CP_FR
998: ,CP_FT
999: ,CP_PR
1000: ,CP_PT) IN ( 'FR' )
1028: AND PST.BUSINESS_GROUP_ID is null
1029: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
1030: AND NVL(PST1.INFORMATION1
1031: ,PST.INFORMATION1) = 'Y'
1032: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
1033: ,PCO.DURATION_UNITS
1034: ,PCO.BUSINESS_GROUP_ID
1035: ,P_REPORT_DATE) < 9
1036: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
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');
1050: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID
1051: ,L_FR
1052: ,L_FT
1053: ,L_PR
1054: ,L_PT);