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_CONTRACTS_F

Line 340: ,per_contracts_f pco

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
341: ,per_shared_types pst
342: ,per_shared_types pst1
343: WHERE peo.person_id = asg.person_id
344: AND peo.person_id = ppea.person_id

Line 580: ,per_contracts_f pco

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
582: ,per_shared_types pst1
583: WHERE peo.person_id = asg.person_id
584: AND peo.person_id = ppea.person_id

Line 729: FROM per_contracts_f pco

725: FROM hr_all_organization_units hou
726: WHERE hou.business_group_id = p_business_group_id
727: AND hou.organization_id = asg.organization_id)
728: AND NOT EXISTS (SELECT 'Y'
729: FROM per_contracts_f pco
730: WHERE pco.person_id = peo.person_id
731: AND p_report_date BETWEEN pco.effective_start_date AND pco.effective_end_date)
732: )
733: GROUP BY '4'

Line 962: ,per_contracts_f pco

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
964: ,per_shared_types pst1
965: WHERE peo.person_id = asg.person_id
966: AND peo.person_id = ppet.person_id

Line 1190: ,per_contracts_f pco

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
1193: WHERE peo.person_id = asg.person_id
1194: AND peo.current_employee_flag = 'Y'

Line 1332: FROM per_contracts_f pco

1328: FROM hr_all_organization_units hou
1329: WHERE hou.business_group_id = p_business_group_id
1330: AND hou.organization_id = asg.organization_id)
1331: AND NOT EXISTS( SELECT 'Y'
1332: FROM per_contracts_f pco
1333: WHERE pco.person_id = peo.person_id
1334: AND p_report_date BETWEEN pco.effective_start_date AND pco.effective_end_date)
1335: )
1336: GROUP BY '04'

Line 1534: ,per_contracts_f pco

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
1536: ,per_shared_types pst1
1537: WHERE peo.person_id = asg.person_id
1538: AND peo.person_id = ppea.person_id

Line 1842: ,per_contracts_f pco

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
1844: ,per_shared_types pst1
1845: ,per_periods_of_service pps
1846: WHERE peo.person_id = asg.person_id

Line 2074: ,per_contracts_f pco

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
2077: ,per_periods_of_service pps
2078: WHERE peo.person_id = asg.person_id

Line 2220: FROM per_contracts_f pco

2216: FROM hr_all_organization_units hou
2217: WHERE hou.business_group_id = p_business_group_id
2218: AND hou.organization_id = asg.organization_id)
2219: AND NOT EXISTS (SELECT 'Y'
2220: FROM per_contracts_f pco
2221: WHERE pco.person_id = peo.person_id
2222: AND p_report_date BETWEEN pco.effective_start_date AND pco.effective_end_date)
2223: )
2224: GROUP BY '4'