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_PERIODS_OF_SERVICE

Line 1730: ,per_periods_of_service pps

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
1732: AND peo.person_id = ppet.person_id
1733: AND ppet.information_type = 'PQH_TENURE_STATUS'
1734: AND ppet.pei_information1 IN ('01','02','04')

Line 1845: ,per_periods_of_service pps

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
1847: AND peo.person_id = ppet.person_id
1848: AND ppet.information_type = 'PQH_TENURE_STATUS'
1849: AND ppet.pei_information1 IN ('03','05')

Line 1961: ,per_periods_of_service pps

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'
1964: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
1965: AND job.business_group_id = p_business_group_id

Line 2077: ,per_periods_of_service pps

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
2079: AND peo.current_employee_flag = 'Y'
2080: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
2081: AND job.business_group_id = p_business_group_id

Line 2189: ,per_periods_of_service pps

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'
2192: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
2193: AND job.business_group_id = p_business_group_id

Line 2296: ,per_periods_of_service pps

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'
2299: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
2300: AND job.business_group_id = p_business_group_id