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.PER_US_IPEDS_PKG dependencies on PER_PAY_PROPOSALS

Line 217: ,per_pay_proposals ppp

213: FROM per_all_people_f peo
214: ,per_all_assignments_f asg
215: ,per_assignment_status_types ast
216: ,per_jobs job
217: ,per_pay_proposals ppp
218: ,per_pay_bases ppb
219: ,per_people_extra_info ppea
220: ,per_people_extra_info ppet
221: WHERE peo.person_id = asg.person_id

Line 243: FROM per_pay_proposals pro

239: AND ast.per_system_status <> 'TERM_ASSIGN'
240: AND asg.pay_basis_id = ppb.pay_basis_id
241: AND asg.assignment_id = ppp.assignment_id
242: AND ppp.change_date = (SELECT MAX(change_date)
243: FROM per_pay_proposals pro
244: WHERE ppp.assignment_id = pro.assignment_id
245: AND pro.change_date <= p_report_date
246: AND pro.approved = 'Y'
247: )

Line 336: ,per_pay_proposals ppp

332: FROM per_all_people_f peo
333: ,per_all_assignments_f asg
334: ,per_assignment_status_types ast
335: ,per_jobs job
336: ,per_pay_proposals ppp
337: ,per_pay_bases ppb
338: ,per_people_extra_info ppea
339: ,per_people_extra_info ppet
340: ,per_contracts_f pco

Line 365: FROM per_pay_proposals pro

361: AND ast.per_system_status <> 'TERM_ASSIGN'
362: AND asg.pay_basis_id = ppb.pay_basis_id
363: AND asg.assignment_id = ppp.assignment_id
364: AND ppp.change_date = (SELECT MAX(change_date)
365: FROM per_pay_proposals pro
366: WHERE ppp.assignment_id = pro.assignment_id
367: AND pro.change_date <= p_report_date
368: AND pro.approved = 'Y'
369: )

Line 463: ,per_pay_proposals ppp

459: FROM per_all_people_f peo
460: ,per_all_assignments_f asg
461: ,per_assignment_status_types ast
462: ,per_jobs job
463: ,per_pay_proposals ppp
464: ,per_pay_bases ppb
465: WHERE peo.person_id = asg.person_id
466: AND peo.current_employee_flag = 'Y'
467: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 479: FROM per_pay_proposals pro

475: AND ast.per_system_status <> 'TERM_ASSIGN'
476: AND asg.pay_basis_id = ppb.pay_basis_id
477: AND asg.assignment_id = ppp.assignment_id
478: AND ppp.change_date = (SELECT MAX(change_date)
479: FROM per_pay_proposals pro
480: WHERE ppp.assignment_id = pro.assignment_id
481: AND pro.change_date <= p_report_date
482: AND pro.approved = 'Y'
483: )

Line 577: ,per_pay_proposals ppp

573: FROM per_all_people_f peo
574: ,per_all_assignments_f asg
575: ,per_assignment_status_types ast
576: ,per_jobs job
577: ,per_pay_proposals ppp
578: ,per_pay_bases ppb
579: ,per_people_extra_info ppea
580: ,per_contracts_f pco
581: ,per_shared_types pst

Line 602: FROM per_pay_proposals pro

598: AND ast.per_system_status <> 'TERM_ASSIGN'
599: AND asg.pay_basis_id = ppb.pay_basis_id
600: AND asg.assignment_id = ppp.assignment_id
601: AND ppp.change_date = (SELECT MAX(change_date)
602: FROM per_pay_proposals pro
603: WHERE ppp.assignment_id = pro.assignment_id
604: AND pro.change_date <= p_report_date
605: AND pro.approved = 'Y'
606: )

Line 699: ,per_pay_proposals ppp

695: FROM per_all_people_f peo
696: ,per_all_assignments_f asg
697: ,per_assignment_status_types ast
698: ,per_jobs job
699: ,per_pay_proposals ppp
700: ,per_pay_bases ppb
701: WHERE peo.person_id = asg.person_id
702: AND peo.current_employee_flag = 'Y'
703: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 715: FROM per_pay_proposals pro

711: AND ast.per_system_status <> 'TERM_ASSIGN'
712: AND asg.pay_basis_id = ppb.pay_basis_id
713: AND asg.assignment_id = ppp.assignment_id
714: AND ppp.change_date = (SELECT MAX(change_date)
715: FROM per_pay_proposals pro
716: WHERE ppp.assignment_id = pro.assignment_id
717: AND pro.change_date <= p_report_date
718: AND pro.approved = 'Y'
719: )

Line 849: ,per_pay_proposals ppp

845: FROM per_all_people_f peo
846: ,per_all_assignments_f asg
847: ,per_assignment_status_types ast
848: ,per_jobs job
849: ,per_pay_proposals ppp
850: ,per_pay_bases ppb
851: ,per_people_extra_info ppet
852: WHERE peo.person_id = asg.person_id
853: AND peo.person_id = ppet.person_id

Line 869: FROM per_pay_proposals pro

865: AND ast.per_system_status <> 'TERM_ASSIGN'
866: AND asg.pay_basis_id = ppb.pay_basis_id
867: AND asg.assignment_id = ppp.assignment_id
868: AND ppp.change_date = (SELECT MAX(change_date)
869: FROM per_pay_proposals pro
870: WHERE ppp.assignment_id = pro.assignment_id
871: AND pro.change_date <= p_report_date
872: AND pro.approved = 'Y'
873: )

Line 959: ,per_pay_proposals ppp

955: FROM per_all_people_f peo
956: ,per_all_assignments_f asg
957: ,per_assignment_status_types ast
958: ,per_jobs job
959: ,per_pay_proposals ppp
960: ,per_pay_bases ppb
961: ,per_people_extra_info ppet
962: ,per_contracts_f pco
963: ,per_shared_types pst

Line 982: FROM per_pay_proposals pro

978: AND ast.per_system_status <> 'TERM_ASSIGN'
979: AND asg.pay_basis_id = ppb.pay_basis_id
980: AND asg.assignment_id = ppp.assignment_id
981: AND ppp.change_date = (SELECT MAX(change_date)
982: FROM per_pay_proposals pro
983: WHERE ppp.assignment_id = pro.assignment_id
984: AND pro.change_date <= p_report_date
985: AND pro.approved = 'Y'
986: )

Line 1076: ,per_pay_proposals ppp

1072: FROM per_all_people_f peo
1073: ,per_all_assignments_f asg
1074: ,per_assignment_status_types ast
1075: ,per_jobs job
1076: ,per_pay_proposals ppp
1077: ,per_pay_bases ppb
1078: WHERE peo.person_id = asg.person_id
1079: AND peo.current_employee_flag = 'Y'
1080: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category

Line 1092: FROM per_pay_proposals pro

1088: AND ast.per_system_status <> 'TERM_ASSIGN'
1089: AND asg.pay_basis_id = ppb.pay_basis_id
1090: AND asg.assignment_id = ppp.assignment_id
1091: AND ppp.change_date = (SELECT MAX(change_date)
1092: FROM per_pay_proposals pro
1093: WHERE ppp.assignment_id = pro.assignment_id
1094: AND pro.change_date <= p_report_date
1095: AND pro.approved = 'Y'
1096: )

Line 1188: ,per_pay_proposals ppp

1184: FROM per_all_people_f peo
1185: ,per_all_assignments_f asg
1186: ,per_assignment_status_types ast
1187: ,per_jobs job
1188: ,per_pay_proposals ppp
1189: ,per_pay_bases ppb
1190: ,per_contracts_f pco
1191: ,per_shared_types pst
1192: ,per_shared_types pst1

Line 1207: FROM per_pay_proposals pro

1203: AND ast.per_system_status <> 'TERM_ASSIGN'
1204: AND asg.pay_basis_id = ppb.pay_basis_id
1205: AND asg.assignment_id = ppp.assignment_id
1206: AND ppp.change_date = (SELECT MAX(change_date)
1207: FROM per_pay_proposals pro
1208: WHERE ppp.assignment_id = pro.assignment_id
1209: AND pro.change_date <= p_report_date
1210: AND pro.approved = 'Y'
1211: )

Line 1302: ,per_pay_proposals ppp

1298: FROM per_all_people_f peo
1299: ,per_all_assignments_f asg
1300: ,per_assignment_status_types ast
1301: ,per_jobs job
1302: ,per_pay_proposals ppp
1303: ,per_pay_bases ppb
1304: WHERE peo.person_id = asg.person_id
1305: AND peo.current_employee_flag = 'Y'
1306: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category

Line 1318: FROM per_pay_proposals pro

1314: AND ast.per_system_status <> 'TERM_ASSIGN'
1315: AND asg.pay_basis_id = ppb.pay_basis_id
1316: AND asg.assignment_id = ppp.assignment_id
1317: AND ppp.change_date = (SELECT MAX(change_date)
1318: FROM per_pay_proposals pro
1319: WHERE ppp.assignment_id = pro.assignment_id
1320: AND pro.change_date <= p_report_date
1321: AND pro.approved = 'Y'
1322: )

Line 1429: ,per_pay_proposals ppp

1425: FROM per_all_people_f peo
1426: ,per_all_assignments_f asg
1427: ,per_assignment_status_types ast
1428: ,per_jobs job
1429: ,per_pay_proposals ppp
1430: ,per_pay_bases ppb
1431: WHERE peo.person_id = asg.person_id
1432: AND peo.current_employee_flag = 'Y'
1433: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'PR'

Line 1445: FROM per_pay_proposals pro

1441: AND ast.per_system_status <> 'TERM_ASSIGN'
1442: AND asg.pay_basis_id = ppb.pay_basis_id
1443: AND asg.assignment_id = ppp.assignment_id
1444: AND ppp.change_date = (SELECT MAX(change_date)
1445: FROM per_pay_proposals pro
1446: WHERE ppp.assignment_id = pro.assignment_id
1447: AND pro.change_date <= p_report_date
1448: AND pro.approved = 'Y'
1449: )

Line 1531: ,per_pay_proposals ppp

1527: FROM per_all_people_f peo
1528: ,per_all_assignments_f asg
1529: ,per_assignment_status_types ast
1530: ,per_jobs job
1531: ,per_pay_proposals ppp
1532: ,per_pay_bases ppb
1533: ,per_people_extra_info ppea
1534: ,per_contracts_f pco
1535: ,per_shared_types pst

Line 1557: FROM per_pay_proposals pro

1553: AND ast.per_system_status <> 'TERM_ASSIGN'
1554: AND asg.pay_basis_id = ppb.pay_basis_id
1555: AND asg.assignment_id = ppp.assignment_id
1556: AND ppp.change_date = (SELECT MAX(change_date)
1557: FROM per_pay_proposals pro
1558: WHERE ppp.assignment_id = pro.assignment_id
1559: AND pro.change_date <= p_report_date
1560: AND pro.approved = 'Y'
1561: )

Line 1602: ,per_pay_proposals ppp

1598: FROM per_all_people_f peo
1599: ,per_all_assignments_f asg
1600: ,per_assignment_status_types ast
1601: ,per_jobs job
1602: ,per_pay_proposals ppp
1603: ,per_pay_bases ppb
1604: WHERE peo.person_id = asg.person_id
1605: AND peo.current_employee_flag = 'Y'
1606: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 1618: FROM per_pay_proposals pro

1614: AND ast.per_system_status <> 'TERM_ASSIGN'
1615: AND asg.pay_basis_id = ppb.pay_basis_id
1616: AND asg.assignment_id = ppp.assignment_id
1617: AND ppp.change_date = (SELECT MAX(change_date)
1618: FROM per_pay_proposals pro
1619: WHERE ppp.assignment_id = pro.assignment_id
1620: AND pro.change_date <= p_report_date
1621: AND pro.approved = 'Y'
1622: )

Line 1727: ,per_pay_proposals ppp

1723: FROM per_all_people_f peo
1724: ,per_all_assignments_f asg
1725: ,per_assignment_status_types ast
1726: ,per_jobs job
1727: ,per_pay_proposals ppp
1728: ,per_pay_bases ppb
1729: ,per_people_extra_info ppet
1730: ,per_periods_of_service pps
1731: WHERE peo.person_id = asg.person_id

Line 1748: FROM per_pay_proposals pro

1744: AND ast.per_system_status <> 'TERM_ASSIGN'
1745: AND asg.pay_basis_id = ppb.pay_basis_id
1746: AND asg.assignment_id = ppp.assignment_id
1747: AND ppp.change_date = (SELECT MAX(change_date)
1748: FROM per_pay_proposals pro
1749: WHERE ppp.assignment_id = pro.assignment_id
1750: AND pro.change_date <= p_report_date
1751: AND pro.approved = 'Y'
1752: )

Line 1839: ,per_pay_proposals ppp

1835: FROM per_all_people_f peo
1836: ,per_all_assignments_f asg
1837: ,per_assignment_status_types ast
1838: ,per_jobs job
1839: ,per_pay_proposals ppp
1840: ,per_pay_bases ppb
1841: ,per_people_extra_info ppet
1842: ,per_contracts_f pco
1843: ,per_shared_types pst

Line 1865: FROM per_pay_proposals pro

1861: AND asg.assignment_id = ppp.assignment_id
1862: AND asg.period_of_service_id = pps.period_of_service_id
1863: AND pps.date_start BETWEEN ADD_MONTHS(p_report_date,-4) AND (p_report_date-1)
1864: AND ppp.change_date = (SELECT MAX(change_date)
1865: FROM per_pay_proposals pro
1866: WHERE ppp.assignment_id = pro.assignment_id
1867: AND pro.change_date <= p_report_date
1868: AND pro.approved = 'Y'
1869: )

Line 1959: ,per_pay_proposals ppp

1955: FROM per_all_people_f peo
1956: ,per_all_assignments_f asg
1957: ,per_assignment_status_types ast
1958: ,per_jobs job
1959: ,per_pay_proposals ppp
1960: ,per_pay_bases ppb
1961: ,per_periods_of_service pps
1962: WHERE peo.person_id = asg.person_id
1963: AND peo.current_employee_flag = 'Y'

Line 1976: FROM per_pay_proposals pro

1972: AND ast.per_system_status <> 'TERM_ASSIGN'
1973: AND asg.pay_basis_id = ppb.pay_basis_id
1974: AND asg.assignment_id = ppp.assignment_id
1975: AND ppp.change_date = (SELECT MAX(change_date)
1976: FROM per_pay_proposals pro
1977: WHERE ppp.assignment_id = pro.assignment_id
1978: AND pro.change_date <= p_report_date
1979: AND pro.approved = 'Y'
1980: )

Line 2072: ,per_pay_proposals ppp

2068: FROM per_all_people_f peo
2069: ,per_all_assignments_f asg
2070: ,per_assignment_status_types ast
2071: ,per_jobs job
2072: ,per_pay_proposals ppp
2073: ,per_pay_bases ppb
2074: ,per_contracts_f pco
2075: ,per_shared_types pst
2076: ,per_shared_types pst1

Line 2092: FROM per_pay_proposals pro

2088: AND ast.per_system_status <> 'TERM_ASSIGN'
2089: AND asg.pay_basis_id = ppb.pay_basis_id
2090: AND asg.assignment_id = ppp.assignment_id
2091: AND ppp.change_date = (SELECT MAX(change_date)
2092: FROM per_pay_proposals pro
2093: WHERE ppp.assignment_id = pro.assignment_id
2094: AND pro.change_date <= p_report_date
2095: AND pro.approved = 'Y'
2096: )

Line 2187: ,per_pay_proposals ppp

2183: FROM per_all_people_f peo
2184: ,per_all_assignments_f asg
2185: ,per_assignment_status_types ast
2186: ,per_jobs job
2187: ,per_pay_proposals ppp
2188: ,per_pay_bases ppb
2189: ,per_periods_of_service pps
2190: WHERE peo.person_id = asg.person_id
2191: AND peo.current_employee_flag = 'Y'

Line 2204: FROM per_pay_proposals pro

2200: AND ast.per_system_status <> 'TERM_ASSIGN'
2201: AND asg.pay_basis_id = ppb.pay_basis_id
2202: AND asg.assignment_id = ppp.assignment_id
2203: AND ppp.change_date = (SELECT MAX(change_date)
2204: FROM per_pay_proposals pro
2205: WHERE ppp.assignment_id = pro.assignment_id
2206: AND pro.change_date <= p_report_date
2207: AND pro.approved = 'Y'
2208: )

Line 2294: ,per_pay_proposals ppp

2290: FROM per_all_people_f peo
2291: ,per_all_assignments_f asg
2292: ,per_assignment_status_types ast
2293: ,per_jobs job
2294: ,per_pay_proposals ppp
2295: ,per_pay_bases ppb
2296: ,per_periods_of_service pps
2297: WHERE peo.person_id = asg.person_id
2298: AND peo.current_employee_flag = 'Y'

Line 2311: FROM per_pay_proposals pro

2307: AND ast.per_system_status <> 'TERM_ASSIGN'
2308: AND asg.pay_basis_id = ppb.pay_basis_id
2309: AND asg.assignment_id = ppp.assignment_id
2310: AND ppp.change_date = (SELECT MAX(change_date)
2311: FROM per_pay_proposals pro
2312: WHERE ppp.assignment_id = pro.assignment_id
2313: AND pro.change_date <= p_report_date
2314: AND pro.approved = 'Y'
2315: )

Line 2429: ,per_pay_proposals ppp

2425: FROM per_all_people_f peo
2426: ,per_all_assignments_f asg
2427: ,per_assignment_status_types ast
2428: ,per_jobs job
2429: ,per_pay_proposals ppp
2430: ,per_pay_bases ppb
2431: WHERE peo.person_id = asg.person_id
2432: AND peo.current_employee_flag = 'Y'
2433: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_employment_category

Line 2445: FROM per_pay_proposals pro

2441: AND ast.per_system_status <> 'TERM_ASSIGN'
2442: AND asg.pay_basis_id = ppb.pay_basis_id
2443: AND asg.assignment_id = ppp.assignment_id
2444: AND ppp.change_date = (SELECT MAX(change_date)
2445: FROM per_pay_proposals pro
2446: WHERE ppp.assignment_id = pro.assignment_id
2447: AND pro.change_date <= p_report_date
2448: AND pro.approved = 'Y'
2449: )