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 403: PER_PAY_PROPOSALS PPP,

399: PER_ASSIGNMENT_STATUS_TYPES AST,
400: PER_PEOPLE_EXTRA_INFO PPEA,
401: PER_PEOPLE_EXTRA_INFO PPET,
402: HR_LOOKUPS HL,
403: PER_PAY_PROPOSALS PPP,
404: PER_PAY_BASES PPB,
405: PER_JOBS JOB
406: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
407: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 446: PER_PAY_PROPOSALS PRO

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

Line 576: PER_PAY_PROPOSALS PPP,

572: PER_ASSIGNMENT_STATUS_TYPES AST,
573: PER_PEOPLE_EXTRA_INFO PPEA,
574: PER_PEOPLE_EXTRA_INFO PPET,
575: HR_LOOKUPS HL,
576: PER_PAY_PROPOSALS PPP,
577: PER_PAY_BASES PPB,
578: PER_JOBS JOB,
579: PER_PEOPLE_EXTRA_INFO PEI
580: WHERE PAF.PERSON_ID = PPEA.PERSON_ID

Line 643: PER_PAY_PROPOSALS PRO

639: AND PPP.CHANGE_DATE = (
640: SELECT
641: MAX(CHANGE_DATE)
642: FROM
643: PER_PAY_PROPOSALS PRO
644: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
645: AND PRO.CHANGE_DATE <= P_REPORT_DATE
646: AND PRO.APPROVED = 'Y' )
647: AND NVL(PPP.PROPOSED_SALARY_N

Line 1012: PER_PAY_PROPOSALS PPP,

1008: PER_ALL_ASSIGNMENTS_F PAF,
1009: PER_ASSIGNMENT_STATUS_TYPES AST,
1010: PER_PEOPLE_EXTRA_INFO PPET,
1011: HR_LOOKUPS HL,
1012: PER_PAY_PROPOSALS PPP,
1013: PER_PAY_BASES PPB,
1014: PER_JOBS JOB
1015: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1016: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1057: PER_PAY_PROPOSALS PRO

1053: AND PPP.CHANGE_DATE = (
1054: SELECT
1055: MAX(CHANGE_DATE)
1056: FROM
1057: PER_PAY_PROPOSALS PRO
1058: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1059: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1060: AND PRO.APPROVED = 'Y' )
1061: AND NVL(PPP.PROPOSED_SALARY_N

Line 1185: PER_PAY_PROPOSALS PPP,

1181: PER_ALL_ASSIGNMENTS_F PAF,
1182: PER_ASSIGNMENT_STATUS_TYPES AST,
1183: PER_PEOPLE_EXTRA_INFO PPET,
1184: HR_LOOKUPS HL,
1185: PER_PAY_PROPOSALS PPP,
1186: PER_PAY_BASES PPB,
1187: PER_JOBS JOB,
1188: PER_PEOPLE_EXTRA_INFO PEI
1189: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 1254: PER_PAY_PROPOSALS PRO

1250: AND PPP.CHANGE_DATE = (
1251: SELECT
1252: MAX(CHANGE_DATE)
1253: FROM
1254: PER_PAY_PROPOSALS PRO
1255: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1256: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1257: AND PRO.APPROVED = 'Y' )
1258: AND NVL(PPP.PROPOSED_SALARY_N

Line 1623: PER_PAY_PROPOSALS PPP,

1619: PER_ASSIGNMENT_STATUS_TYPES AST,
1620: PER_PEOPLE_EXTRA_INFO PPEA,
1621: PER_PEOPLE_EXTRA_INFO PPET,
1622: HR_LOOKUPS HL,
1623: PER_PAY_PROPOSALS PPP,
1624: PER_PAY_BASES PPB,
1625: PER_JOBS JOB
1626: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1627: AND PAF.PERSON_ID = PPET.PERSON_ID

Line 1666: PER_PAY_PROPOSALS PRO

1662: AND PPP.CHANGE_DATE = (
1663: SELECT
1664: MAX(CHANGE_DATE)
1665: FROM
1666: PER_PAY_PROPOSALS PRO
1667: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1668: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1669: AND PRO.APPROVED = 'Y' )
1670: AND NVL(PPP.PROPOSED_SALARY_N

Line 1796: PER_PAY_PROPOSALS PPP,

1792: PER_ASSIGNMENT_STATUS_TYPES AST,
1793: PER_PEOPLE_EXTRA_INFO PPEA,
1794: PER_PEOPLE_EXTRA_INFO PPET,
1795: HR_LOOKUPS HL,
1796: PER_PAY_PROPOSALS PPP,
1797: PER_PAY_BASES PPB,
1798: PER_JOBS JOB,
1799: PER_PEOPLE_EXTRA_INFO PEI
1800: WHERE PAF.PERSON_ID = PPEA.PERSON_ID

Line 1863: PER_PAY_PROPOSALS PRO

1859: AND PPP.CHANGE_DATE = (
1860: SELECT
1861: MAX(CHANGE_DATE)
1862: FROM
1863: PER_PAY_PROPOSALS PRO
1864: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1865: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1866: AND PRO.APPROVED = 'Y' )
1867: AND NVL(PPP.PROPOSED_SALARY_N

Line 2231: PER_PAY_PROPOSALS PPP,

2227: PER_ALL_ASSIGNMENTS_F PAF,
2228: PER_ASSIGNMENT_STATUS_TYPES AST,
2229: PER_PEOPLE_EXTRA_INFO PPET,
2230: HR_LOOKUPS HL,
2231: PER_PAY_PROPOSALS PPP,
2232: PER_PAY_BASES PPB,
2233: PER_JOBS JOB
2234: WHERE PAF.PERSON_ID = PPET.PERSON_ID
2235: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 2276: PER_PAY_PROPOSALS PRO

2272: AND PPP.CHANGE_DATE = (
2273: SELECT
2274: MAX(CHANGE_DATE)
2275: FROM
2276: PER_PAY_PROPOSALS PRO
2277: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2278: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2279: AND PRO.APPROVED = 'Y' )
2280: AND NVL(PPP.PROPOSED_SALARY_N

Line 2405: PER_PAY_PROPOSALS PPP,

2401: PER_ALL_ASSIGNMENTS_F PAF,
2402: PER_ASSIGNMENT_STATUS_TYPES AST,
2403: PER_PEOPLE_EXTRA_INFO PPET,
2404: HR_LOOKUPS HL,
2405: PER_PAY_PROPOSALS PPP,
2406: PER_PAY_BASES PPB,
2407: PER_JOBS JOB,
2408: PER_PEOPLE_EXTRA_INFO PEI
2409: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 2474: PER_PAY_PROPOSALS PRO

2470: AND PPP.CHANGE_DATE = (
2471: SELECT
2472: MAX(CHANGE_DATE)
2473: FROM
2474: PER_PAY_PROPOSALS PRO
2475: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2476: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2477: AND PRO.APPROVED = 'Y' )
2478: AND NVL(PPP.PROPOSED_SALARY_N

Line 2842: PER_PAY_PROPOSALS PPP,

2838: PER_ALL_ASSIGNMENTS_F PAF,
2839: PER_ASSIGNMENT_STATUS_TYPES AST,
2840: PER_PEOPLE_EXTRA_INFO PPEA,
2841: HR_LOOKUPS HL,
2842: PER_PAY_PROPOSALS PPP,
2843: PER_PAY_BASES PPB,
2844: PER_JOBS JOB
2845: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2846: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2889: PER_PAY_PROPOSALS PRO

2885: AND PPP.CHANGE_DATE = (
2886: SELECT
2887: MAX(CHANGE_DATE)
2888: FROM
2889: PER_PAY_PROPOSALS PRO
2890: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
2891: AND PRO.CHANGE_DATE <= P_REPORT_DATE
2892: AND PRO.APPROVED = 'Y' )
2893: AND NVL(PPP.PROPOSED_SALARY_N

Line 3019: PER_PAY_PROPOSALS PPP,

3015: PER_ALL_ASSIGNMENTS_F PAF,
3016: PER_ASSIGNMENT_STATUS_TYPES AST,
3017: PER_PEOPLE_EXTRA_INFO PPEA,
3018: HR_LOOKUPS HL,
3019: PER_PAY_PROPOSALS PPP,
3020: PER_PAY_BASES PPB,
3021: PER_JOBS JOB,
3022: PER_PEOPLE_EXTRA_INFO PEI
3023: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 3090: PER_PAY_PROPOSALS PRO

3086: AND PPP.CHANGE_DATE = (
3087: SELECT
3088: MAX(CHANGE_DATE)
3089: FROM
3090: PER_PAY_PROPOSALS PRO
3091: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
3092: AND PRO.CHANGE_DATE <= P_REPORT_DATE
3093: AND PRO.APPROVED = 'Y' )
3094: AND NVL(PPP.PROPOSED_SALARY_N

Line 3457: PER_PAY_PROPOSALS PPP,

3453: PER_ALL_PEOPLE_F PEO,
3454: PER_ALL_ASSIGNMENTS_F PAF,
3455: PER_ASSIGNMENT_STATUS_TYPES AST,
3456: HR_LOOKUPS HL,
3457: PER_PAY_PROPOSALS PPP,
3458: PER_PAY_BASES PPB,
3459: PER_JOBS JOB
3460: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3461: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 3506: PER_PAY_PROPOSALS PRO

3502: AND PPP.CHANGE_DATE = (
3503: SELECT
3504: MAX(CHANGE_DATE)
3505: FROM
3506: PER_PAY_PROPOSALS PRO
3507: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
3508: AND PRO.CHANGE_DATE <= P_REPORT_DATE
3509: AND PRO.APPROVED = 'Y' )
3510: AND NVL(PPP.PROPOSED_SALARY_N

Line 3633: PER_PAY_PROPOSALS PPP,

3629: PER_ALL_PEOPLE_F PEO,
3630: PER_ALL_ASSIGNMENTS_F PAF,
3631: PER_ASSIGNMENT_STATUS_TYPES AST,
3632: HR_LOOKUPS HL,
3633: PER_PAY_PROPOSALS PPP,
3634: PER_PAY_BASES PPB,
3635: PER_JOBS JOB,
3636: PER_PEOPLE_EXTRA_INFO PEI
3637: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 3706: PER_PAY_PROPOSALS PRO

3702: AND PPP.CHANGE_DATE = (
3703: SELECT
3704: MAX(CHANGE_DATE)
3705: FROM
3706: PER_PAY_PROPOSALS PRO
3707: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
3708: AND PRO.CHANGE_DATE <= P_REPORT_DATE
3709: AND PRO.APPROVED = 'Y' )
3710: AND NVL(PPP.PROPOSED_SALARY_N