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 PER_PAY_PROPOSALS

Line 208: PER_PAY_PROPOSALS PPP,

204: PER_ASSIGNMENT_STATUS_TYPES AST,
205: PER_PEOPLE_EXTRA_INFO PPEA,
206: PER_PEOPLE_EXTRA_INFO PPET,
207: HR_LOOKUPS HL,
208: PER_PAY_PROPOSALS PPP,
209: PER_PAY_BASES PPB,
210: PER_JOBS JOB
211: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
212: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 251: PER_PAY_PROPOSALS PRO

247: AND PPP.CHANGE_DATE = (
248: SELECT
249: MAX(CHANGE_DATE)
250: FROM
251: PER_PAY_PROPOSALS PRO
252: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
253: AND PRO.CHANGE_DATE <= P_REPORT_DATE
254: AND PRO.APPROVED = 'Y' )
255: AND NVL(PPP.PROPOSED_SALARY_N

Line 380: PER_PAY_PROPOSALS PPP,

376: PER_ASSIGNMENT_STATUS_TYPES AST,
377: PER_PEOPLE_EXTRA_INFO PPEA,
378: PER_PEOPLE_EXTRA_INFO PPET,
379: HR_LOOKUPS HL,
380: PER_PAY_PROPOSALS PPP,
381: PER_PAY_BASES PPB,
382: PER_JOBS JOB,
383: PER_PEOPLE_EXTRA_INFO PEI
384: WHERE PAF.PERSON_ID = PPEA.PERSON_ID

Line 447: PER_PAY_PROPOSALS PRO

443: AND PPP.CHANGE_DATE = (
444: SELECT
445: MAX(CHANGE_DATE)
446: FROM
447: PER_PAY_PROPOSALS PRO
448: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
449: AND PRO.CHANGE_DATE <= P_REPORT_DATE
450: AND PRO.APPROVED = 'Y' )
451: AND NVL(PPP.PROPOSED_SALARY_N

Line 626: PER_PAY_PROPOSALS PPP,

622: PER_ALL_ASSIGNMENTS_F PAF,
623: PER_ASSIGNMENT_STATUS_TYPES AST,
624: PER_PEOPLE_EXTRA_INFO PPET,
625: HR_LOOKUPS HL,
626: PER_PAY_PROPOSALS PPP,
627: PER_PAY_BASES PPB,
628: PER_JOBS JOB
629: WHERE PAF.PERSON_ID = PPET.PERSON_ID
630: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 671: PER_PAY_PROPOSALS PRO

667: AND PPP.CHANGE_DATE = (
668: SELECT
669: MAX(CHANGE_DATE)
670: FROM
671: PER_PAY_PROPOSALS PRO
672: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
673: AND PRO.CHANGE_DATE <= P_REPORT_DATE
674: AND PRO.APPROVED = 'Y' )
675: AND NVL(PPP.PROPOSED_SALARY_N

Line 798: PER_PAY_PROPOSALS PPP,

794: PER_ALL_ASSIGNMENTS_F PAF,
795: PER_ASSIGNMENT_STATUS_TYPES AST,
796: PER_PEOPLE_EXTRA_INFO PPET,
797: HR_LOOKUPS HL,
798: PER_PAY_PROPOSALS PPP,
799: PER_PAY_BASES PPB,
800: PER_JOBS JOB,
801: PER_PEOPLE_EXTRA_INFO PEI
802: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 867: PER_PAY_PROPOSALS PRO

863: AND PPP.CHANGE_DATE = (
864: SELECT
865: MAX(CHANGE_DATE)
866: FROM
867: PER_PAY_PROPOSALS PRO
868: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
869: AND PRO.CHANGE_DATE <= P_REPORT_DATE
870: AND PRO.APPROVED = 'Y' )
871: AND NVL(PPP.PROPOSED_SALARY_N

Line 1047: PER_PAY_PROPOSALS PPP,

1043: PER_ASSIGNMENT_STATUS_TYPES AST,
1044: PER_PEOPLE_EXTRA_INFO PPEA,
1045: PER_PEOPLE_EXTRA_INFO PPET,
1046: HR_LOOKUPS HL,
1047: PER_PAY_PROPOSALS PPP,
1048: PER_PAY_BASES PPB,
1049: PER_JOBS JOB
1050: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1051: AND PAF.PERSON_ID = PPET.PERSON_ID

Line 1090: PER_PAY_PROPOSALS PRO

1086: AND PPP.CHANGE_DATE = (
1087: SELECT
1088: MAX(CHANGE_DATE)
1089: FROM
1090: PER_PAY_PROPOSALS PRO
1091: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1092: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1093: AND PRO.APPROVED = 'Y' )
1094: AND NVL(PPP.PROPOSED_SALARY_N

Line 1219: PER_PAY_PROPOSALS PPP,

1215: PER_ASSIGNMENT_STATUS_TYPES AST,
1216: PER_PEOPLE_EXTRA_INFO PPEA,
1217: PER_PEOPLE_EXTRA_INFO PPET,
1218: HR_LOOKUPS HL,
1219: PER_PAY_PROPOSALS PPP,
1220: PER_PAY_BASES PPB,
1221: PER_JOBS JOB,
1222: PER_PEOPLE_EXTRA_INFO PEI
1223: WHERE PAF.PERSON_ID = PPEA.PERSON_ID

Line 1286: PER_PAY_PROPOSALS PRO

1282: AND PPP.CHANGE_DATE = (
1283: SELECT
1284: MAX(CHANGE_DATE)
1285: FROM
1286: PER_PAY_PROPOSALS PRO
1287: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1288: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1289: AND PRO.APPROVED = 'Y' )
1290: AND NVL(PPP.PROPOSED_SALARY_N

Line 1465: PER_PAY_PROPOSALS PPP,

1461: PER_ALL_ASSIGNMENTS_F PAF,
1462: PER_ASSIGNMENT_STATUS_TYPES AST,
1463: PER_PEOPLE_EXTRA_INFO PPET,
1464: HR_LOOKUPS HL,
1465: PER_PAY_PROPOSALS PPP,
1466: PER_PAY_BASES PPB,
1467: PER_JOBS JOB
1468: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1469: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1510: PER_PAY_PROPOSALS PRO

1506: AND PPP.CHANGE_DATE = (
1507: SELECT
1508: MAX(CHANGE_DATE)
1509: FROM
1510: PER_PAY_PROPOSALS PRO
1511: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1512: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1513: AND PRO.APPROVED = 'Y' )
1514: AND NVL(PPP.PROPOSED_SALARY_N

Line 1637: PER_PAY_PROPOSALS PPP,

1633: PER_ALL_ASSIGNMENTS_F PAF,
1634: PER_ASSIGNMENT_STATUS_TYPES AST,
1635: PER_PEOPLE_EXTRA_INFO PPET,
1636: HR_LOOKUPS HL,
1637: PER_PAY_PROPOSALS PPP,
1638: PER_PAY_BASES PPB,
1639: PER_JOBS JOB,
1640: PER_PEOPLE_EXTRA_INFO PEI
1641: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 1706: PER_PAY_PROPOSALS PRO

1702: AND PPP.CHANGE_DATE = (
1703: SELECT
1704: MAX(CHANGE_DATE)
1705: FROM
1706: PER_PAY_PROPOSALS PRO
1707: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1708: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1709: AND PRO.APPROVED = 'Y' )
1710: AND NVL(PPP.PROPOSED_SALARY_N

Line 1885: PER_PAY_PROPOSALS PPP,

1881: PER_ALL_ASSIGNMENTS_F PAF,
1882: PER_ASSIGNMENT_STATUS_TYPES AST,
1883: PER_PEOPLE_EXTRA_INFO PPEA,
1884: HR_LOOKUPS HL,
1885: PER_PAY_PROPOSALS PPP,
1886: PER_PAY_BASES PPB,
1887: PER_JOBS JOB
1888: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1889: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1932: PER_PAY_PROPOSALS PRO

1928: AND PPP.CHANGE_DATE = (
1929: SELECT
1930: MAX(CHANGE_DATE)
1931: FROM
1932: PER_PAY_PROPOSALS PRO
1933: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1934: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1935: AND PRO.APPROVED = 'Y' )
1936: AND NVL(PPP.PROPOSED_SALARY_N

Line 2060: PER_PAY_PROPOSALS PPP,

2056: PER_ALL_ASSIGNMENTS_F PAF,
2057: PER_ASSIGNMENT_STATUS_TYPES AST,
2058: PER_PEOPLE_EXTRA_INFO PPEA,
2059: HR_LOOKUPS HL,
2060: PER_PAY_PROPOSALS PPP,
2061: PER_PAY_BASES PPB,
2062: PER_JOBS JOB,
2063: PER_PEOPLE_EXTRA_INFO PEI
2064: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 2131: PER_PAY_PROPOSALS PRO

2127: AND PPP.CHANGE_DATE = (
2128: SELECT
2129: MAX(CHANGE_DATE)
2130: FROM
2131: PER_PAY_PROPOSALS PRO
2132: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2133: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2134: AND PRO.APPROVED = 'Y' )
2135: AND NVL(PPP.PROPOSED_SALARY_N

Line 2309: PER_PAY_PROPOSALS PPP,

2305: PER_ALL_PEOPLE_F PEO,
2306: PER_ALL_ASSIGNMENTS_F PAF,
2307: PER_ASSIGNMENT_STATUS_TYPES AST,
2308: HR_LOOKUPS HL,
2309: PER_PAY_PROPOSALS PPP,
2310: PER_PAY_BASES PPB,
2311: PER_JOBS JOB
2312: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2313: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2358: PER_PAY_PROPOSALS PRO

2354: AND PPP.CHANGE_DATE = (
2355: SELECT
2356: MAX(CHANGE_DATE)
2357: FROM
2358: PER_PAY_PROPOSALS PRO
2359: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2360: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2361: AND PRO.APPROVED = 'Y' )
2362: AND NVL(PPP.PROPOSED_SALARY_N

Line 2484: PER_PAY_PROPOSALS PPP,

2480: PER_ALL_PEOPLE_F PEO,
2481: PER_ALL_ASSIGNMENTS_F PAF,
2482: PER_ASSIGNMENT_STATUS_TYPES AST,
2483: HR_LOOKUPS HL,
2484: PER_PAY_PROPOSALS PPP,
2485: PER_PAY_BASES PPB,
2486: PER_JOBS JOB,
2487: PER_PEOPLE_EXTRA_INFO PEI
2488: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 2557: PER_PAY_PROPOSALS PRO

2553: AND PPP.CHANGE_DATE = (
2554: SELECT
2555: MAX(CHANGE_DATE)
2556: FROM
2557: PER_PAY_PROPOSALS PRO
2558: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2559: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2560: AND PRO.APPROVED = 'Y' )
2561: AND NVL(PPP.PROPOSED_SALARY_N