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_PQIPED8_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 235: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

231: AND PAF.PRIMARY_FLAG = 'Y'
232: AND PAF.ASSIGNMENT_TYPE = 'E'
233: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
234: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
235: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
236: ,CP_FR
237: ,CP_FT
238: ,CP_PR
239: ,CP_PT) IN ( 'FR' )

Line 431: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

427: AND PAF.PRIMARY_FLAG = 'Y'
428: AND PAF.ASSIGNMENT_TYPE = 'E'
429: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
430: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
431: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
432: ,CP_FR
433: ,CP_FT
434: ,CP_PR
435: ,CP_PT) IN ( 'FR' )

Line 655: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

651: AND PAF.PRIMARY_FLAG = 'Y'
652: AND PAF.ASSIGNMENT_TYPE = 'E'
653: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
654: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
655: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
656: ,CP_FR
657: ,CP_FT
658: ,CP_PR
659: ,CP_PT) IN ( 'FR' )

Line 851: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

847: AND PAF.PRIMARY_FLAG = 'Y'
848: AND PAF.ASSIGNMENT_TYPE = 'E'
849: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
850: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
851: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
852: ,CP_FR
853: ,CP_FT
854: ,CP_PR
855: ,CP_PT) IN ( 'FR' )

Line 1074: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1070: AND PAF.PRIMARY_FLAG = 'Y'
1071: AND PAF.ASSIGNMENT_TYPE = 'E'
1072: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1073: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1074: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1075: ,CP_FR
1076: ,CP_FT
1077: ,CP_PR
1078: ,CP_PT) IN ( 'FR' )

Line 1270: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1266: AND PAF.PRIMARY_FLAG = 'Y'
1267: AND PAF.ASSIGNMENT_TYPE = 'E'
1268: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1269: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1270: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1271: ,CP_FR
1272: ,CP_FT
1273: ,CP_PR
1274: ,CP_PT) IN ( 'FR' )

Line 1494: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1490: AND PAF.PRIMARY_FLAG = 'Y'
1491: AND PAF.ASSIGNMENT_TYPE = 'E'
1492: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1493: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1494: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1495: ,CP_FR
1496: ,CP_FT
1497: ,CP_PR
1498: ,CP_PT) IN ( 'FR' )

Line 1690: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1686: AND PAF.PRIMARY_FLAG = 'Y'
1687: AND PAF.ASSIGNMENT_TYPE = 'E'
1688: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1689: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1690: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1691: ,CP_FR
1692: ,CP_FT
1693: ,CP_PR
1694: ,CP_PT) IN ( 'FR' )

Line 1916: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

1912: AND PAF.PRIMARY_FLAG = 'Y'
1913: AND PAF.ASSIGNMENT_TYPE = 'E'
1914: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
1915: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
1916: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
1917: ,CP_FR
1918: ,CP_FT
1919: ,CP_PR
1920: ,CP_PT) IN ( 'FR' )

Line 2115: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

2111: AND PAF.PRIMARY_FLAG = 'Y'
2112: AND PAF.ASSIGNMENT_TYPE = 'E'
2113: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
2114: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
2115: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
2116: ,CP_FR
2117: ,CP_FT
2118: ,CP_PR
2119: ,CP_PT) IN ( 'FR' )

Line 2342: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

2338: AND PAF.PRIMARY_FLAG = 'Y'
2339: AND PAF.ASSIGNMENT_TYPE = 'E'
2340: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
2341: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
2342: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
2343: ,CP_FR
2344: ,CP_FT
2345: ,CP_PR
2346: ,CP_PT) IN ( 'FR' )

Line 2541: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY

2537: AND PAF.PRIMARY_FLAG = 'Y'
2538: AND PAF.ASSIGNMENT_TYPE = 'E'
2539: AND PAF.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
2540: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
2541: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(PAF.EMPLOYMENT_CATEGORY
2542: ,CP_FR
2543: ,CP_FT
2544: ,CP_PR
2545: ,CP_PT) IN ( 'FR' )

Line 2572: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID

2568: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
2569: BEGIN
2570: -- HR_STANDARD.EVENT('BEFORE REPORT');
2571: CP_REPORT_DATE := to_char(P_REPORT_DATE,'DD-MON-YYYY');
2572: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID
2573: ,L_FR
2574: ,L_FT
2575: ,L_PR
2576: ,L_PT);