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 414: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE

410: WHERE PAF.PERSON_ID = PPET.PERSON_ID
411: AND PAF.PERSON_ID = PEO.PERSON_ID
412: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
413: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
414: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
415: AND P_REPORT_DATE
416: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
417: AND PPET.PEI_INFORMATION1 = '01'
418: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 423: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

419: AND PAF.PRIMARY_FLAG = 'Y'
420: AND PAF.ASSIGNMENT_TYPE = 'E'
421: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
422: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
423: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
424: ,CP_FR
425: ,CP_FT
426: ,CP_PR
427: ,CP_PT) = 'FR'

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

579: FROM
580: PER_PEOPLE_EXTRA_INFO PEI3
581: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
582: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
583: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
584: AND P_REPORT_DATE
585: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
586: AND PPET.PEI_INFORMATION1 = '01'
587: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 592: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

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

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

963: WHERE PAF.PERSON_ID = PPET.PERSON_ID
964: AND PAF.PERSON_ID = PEO.PERSON_ID
965: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
966: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
967: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
968: AND P_REPORT_DATE
969: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
970: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
971: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 976: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

972: AND PAF.PRIMARY_FLAG = 'Y'
973: AND PAF.ASSIGNMENT_TYPE = 'E'
974: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
975: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
976: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
977: ,CP_FR
978: ,CP_FT
979: ,CP_PR
980: ,CP_PT) = 'FR'

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

1132: FROM
1133: PER_PEOPLE_EXTRA_INFO PEI3
1134: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1135: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
1136: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1137: AND P_REPORT_DATE
1138: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
1139: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
1140: AND PPET.PEI_INFORMATION1 IS NOT NULL

Line 1145: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1141: AND PAF.PRIMARY_FLAG = 'Y'
1142: AND PAF.ASSIGNMENT_TYPE = 'E'
1143: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1144: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1145: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1146: ,CP_FR
1147: ,CP_FT
1148: ,CP_PR
1149: ,CP_PT) = 'FR'

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

1522: WHERE PET.PERSON_ID = PEO.PERSON_ID
1523: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1524: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1525: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1526: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1527: AND P_REPORT_DATE
1528: AND PAF.PRIMARY_FLAG = 'Y'
1529: AND PAF.ASSIGNMENT_TYPE = 'E'
1530: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID

Line 1532: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1528: AND PAF.PRIMARY_FLAG = 'Y'
1529: AND PAF.ASSIGNMENT_TYPE = 'E'
1530: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1531: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1532: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1533: ,CP_FR
1534: ,CP_FT
1535: ,CP_PR
1536: ,CP_PT) = 'FR'

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

1694: WHERE PET.PERSON_ID = PEO.PERSON_ID
1695: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1696: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1697: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1698: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1699: AND P_REPORT_DATE
1700: AND PAF.PRIMARY_FLAG = 'Y'
1701: AND PAF.ASSIGNMENT_TYPE = 'E'
1702: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID

Line 1704: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1700: AND PAF.PRIMARY_FLAG = 'Y'
1701: AND PAF.ASSIGNMENT_TYPE = 'E'
1702: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1703: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1704: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1705: ,CP_FR
1706: ,CP_FT
1707: ,CP_PR
1708: ,CP_PT) = 'FR'

Line 2088: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

2084: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
2085: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
2086: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
2087: AND HL.LOOKUP_CODE not in ( '1' , '2' , '3' , '4' , '12' )
2088: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
2089: ,CP_FR
2090: ,CP_FT
2091: ,CP_PR
2092: ,CP_PT) = 'FR'

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

2089: ,CP_FR
2090: ,CP_FT
2091: ,CP_PR
2092: ,CP_PT) = 'FR'
2093: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
2094: AND P_REPORT_DATE
2095: AND PAF.PRIMARY_FLAG = 'Y'
2096: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
2097: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'

Line 2251: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

2247: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
2248: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
2249: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
2250: AND HL.LOOKUP_CODE not in ( '1' , '2' , '3' , '4' , '12' )
2251: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
2252: ,CP_FR
2253: ,CP_FT
2254: ,CP_PR
2255: ,CP_PT) = 'FR'

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

2252: ,CP_FR
2253: ,CP_FT
2254: ,CP_PR
2255: ,CP_PT) = 'FR'
2256: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
2257: AND P_REPORT_DATE
2258: AND PAF.PRIMARY_FLAG = 'Y'
2259: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
2260: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'

Line 2273: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID

2269: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
2270: Commented for IPED Enh #7033011 End*/
2271: BEGIN
2272: --HR_STANDARD.EVENT('BEFORE REPORT');
2273: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID
2274: ,L_FR
2275: ,L_FT
2276: ,L_PR
2277: ,L_PT);