eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PQIPED9_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 221: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

217: WHERE PAF.PERSON_ID = PPET.PERSON_ID
218: AND PAF.PERSON_ID = PEO.PERSON_ID
219: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
220: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
221: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
222: AND P_REPORT_DATE
223: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
224: AND PPET.PEI_INFORMATION1 = '01'
225: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 230: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

226: AND PAF.PRIMARY_FLAG = 'Y'
227: AND PAF.ASSIGNMENT_TYPE = 'E'
228: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
229: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
230: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
231: ,CP_FR
232: ,CP_FT
233: ,CP_PR
234: ,CP_PT) = 'FR'

Line 389: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

385: FROM
386: PER_PEOPLE_EXTRA_INFO PEI3
387: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
388: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
389: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
390: AND P_REPORT_DATE
391: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
392: AND PPET.PEI_INFORMATION1 = '01'
393: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 398: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

394: AND PAF.PRIMARY_FLAG = 'Y'
395: AND PAF.ASSIGNMENT_TYPE = 'E'
396: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
397: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
398: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
399: ,CP_FR
400: ,CP_FT
401: ,CP_PR
402: ,CP_PT) = 'FR'

Line 584: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

580: WHERE PAF.PERSON_ID = PPET.PERSON_ID
581: AND PAF.PERSON_ID = PEO.PERSON_ID
582: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
583: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
584: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
585: AND P_REPORT_DATE
586: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
587: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
588: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 593: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

589: AND PAF.PRIMARY_FLAG = 'Y'
590: AND PAF.ASSIGNMENT_TYPE = 'E'
591: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
592: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
593: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
594: ,CP_FR
595: ,CP_FT
596: ,CP_PR
597: ,CP_PT) = 'FR'

Line 752: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

748: FROM
749: PER_PEOPLE_EXTRA_INFO PEI3
750: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
751: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
752: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
753: AND P_REPORT_DATE
754: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
755: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
756: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 761: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

757: AND PAF.PRIMARY_FLAG = 'Y'
758: AND PAF.ASSIGNMENT_TYPE = 'E'
759: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
760: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
761: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
762: ,CP_FR
763: ,CP_FT
764: ,CP_PR
765: ,CP_PT) = 'FR'

Line 953: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

949: WHERE PET.PERSON_ID = PEO.PERSON_ID
950: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
951: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
952: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
953: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
954: AND P_REPORT_DATE
955: AND PAF.PRIMARY_FLAG = 'Y'
956: AND PAF.ASSIGNMENT_TYPE = 'E'
957: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID

Line 959: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

955: AND PAF.PRIMARY_FLAG = 'Y'
956: AND PAF.ASSIGNMENT_TYPE = 'E'
957: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
958: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
959: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
960: ,CP_FR
961: ,CP_FT
962: ,CP_PR
963: ,CP_PT) = 'FR'

Line 1124: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

1120: WHERE PET.PERSON_ID = PEO.PERSON_ID
1121: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1122: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1123: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1124: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1125: AND P_REPORT_DATE
1126: AND PAF.PRIMARY_FLAG = 'Y'
1127: AND PAF.ASSIGNMENT_TYPE = 'E'
1128: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID

Line 1130: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1126: AND PAF.PRIMARY_FLAG = 'Y'
1127: AND PAF.ASSIGNMENT_TYPE = 'E'
1128: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1129: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1130: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1131: ,CP_FR
1132: ,CP_FT
1133: ,CP_PR
1134: ,CP_PT) = 'FR'

Line 1325: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1321: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
1322: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
1323: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
1324: AND HL.LOOKUP_CODE not in ( '1' , '2' , '3' , '4' , '12' )
1325: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1326: ,CP_FR
1327: ,CP_FT
1328: ,CP_PR
1329: ,CP_PT) = 'FR'

Line 1330: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

1326: ,CP_FR
1327: ,CP_FT
1328: ,CP_PR
1329: ,CP_PT) = 'FR'
1330: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1331: AND P_REPORT_DATE
1332: AND PAF.PRIMARY_FLAG = 'Y'
1333: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1334: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'

Line 1487: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1483: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
1484: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
1485: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
1486: AND HL.LOOKUP_CODE not in ( '1' , '2' , '3' , '4' , '12' )
1487: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1488: ,CP_FR
1489: ,CP_FT
1490: ,CP_PR
1491: ,CP_PT) = 'FR'

Line 1492: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

1488: ,CP_FR
1489: ,CP_FT
1490: ,CP_PR
1491: ,CP_PT) = 'FR'
1492: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1493: AND P_REPORT_DATE
1494: AND PAF.PRIMARY_FLAG = 'Y'
1495: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1496: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'

Line 1508: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID

1504: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID )
1505: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
1506: BEGIN
1507: --HR_STANDARD.EVENT('BEFORE REPORT');
1508: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID
1509: ,L_FR
1510: ,L_FT
1511: ,L_PR
1512: ,L_PT);