[Home] [Help]
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)
579: PER_SHARED_TYPES PST1
580: WHERE PEO.PERSON_ID = ASS.PERSON_ID
581: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
582: AND PCO.PERSON_ID = PEO.PERSON_ID
583: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
584: ,CP_FR
585: ,CP_FT
586: ,CP_PR
587: ,CP_PT) IN ( 'FR' )
615: AND PST.BUSINESS_GROUP_ID is null
616: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
617: AND NVL(PST1.INFORMATION1
618: ,PST.INFORMATION1) = 'Y'
619: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
620: ,PCO.DURATION_UNITS
621: ,PCO.BUSINESS_GROUP_ID
622: ,P_REPORT_DATE) BETWEEN C_DURATION1
623: AND C_DURATION2
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)
786: FROM
787: PER_PEOPLE_EXTRA_INFO PEI3
788: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
789: AND PCO.PERSON_ID = PEO.PERSON_ID
790: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
791: ,CP_FR
792: ,CP_FT
793: ,CP_PR
794: ,CP_PT) IN ( 'FR' )
822: AND PST.BUSINESS_GROUP_ID is null
823: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
824: AND NVL(PST1.INFORMATION1
825: ,PST.INFORMATION1) = 'Y'
826: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
827: ,PCO.DURATION_UNITS
828: ,PCO.BUSINESS_GROUP_ID
829: ,P_REPORT_DATE) BETWEEN C_DURATION1
830: AND C_DURATION2
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)
1214: PER_SHARED_TYPES PST1
1215: WHERE PEO.PERSON_ID = ASS.PERSON_ID
1216: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1217: AND PCO.PERSON_ID = PEO.PERSON_ID
1218: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
1219: ,CP_FR
1220: ,CP_FT
1221: ,CP_PR
1222: ,CP_PT) IN ( 'FR' )
1250: AND PST.BUSINESS_GROUP_ID is null
1251: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
1252: AND NVL(PST1.INFORMATION1
1253: ,PST.INFORMATION1) = 'Y'
1254: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
1255: ,PCO.DURATION_UNITS
1256: ,PCO.BUSINESS_GROUP_ID
1257: ,P_REPORT_DATE) < 9
1258: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
1413: FROM
1414: PER_PEOPLE_EXTRA_INFO PEI3
1415: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1416: AND PCO.PERSON_ID = PEO.PERSON_ID
1417: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
1418: ,CP_FR
1419: ,CP_FT
1420: ,CP_PR
1421: ,CP_PT) IN ( 'FR' )
1449: AND PST.BUSINESS_GROUP_ID is null
1450: AND pst1.business_group_id (+) = P_BUSINESS_GROUP_ID
1451: AND NVL(PST1.INFORMATION1
1452: ,PST.INFORMATION1) = 'Y'
1453: AND PQH_EMPLOYMENT_CATEGORY.GET_DURATION_IN_MONTHS(PCO.DURATION
1454: ,PCO.DURATION_UNITS
1455: ,PCO.BUSINESS_GROUP_ID
1456: ,P_REPORT_DATE) < 9
1457: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
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
1473: ,L_FR
1474: ,L_FT
1475: ,L_PR
1476: ,L_PT);