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_SHARED_TYPES

Line 341: ,per_shared_types pst

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
345: AND peo.person_id = ppet.person_id

Line 342: ,per_shared_types pst1

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
345: AND peo.person_id = ppet.person_id
346: AND ppea.information_type = 'PQH_ACADEMIC_RANK'

Line 581: ,per_shared_types pst

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
585: AND ppea.information_type = 'PQH_ACADEMIC_RANK'

Line 582: ,per_shared_types pst1

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
585: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
586: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

Line 963: ,per_shared_types pst

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
967: AND ppet.information_type = 'PQH_TENURE_STATUS'

Line 964: ,per_shared_types pst1

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
967: AND ppet.information_type = 'PQH_TENURE_STATUS'
968: AND ppet.pei_information1 IN ('03','05')

Line 1191: ,per_shared_types pst

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'
1195: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category

Line 1192: ,per_shared_types pst1

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'
1195: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category
1196: AND job.job_information_category = 'US'

Line 1535: ,per_shared_types pst

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
1539: AND ppea.information_type = 'PQH_ACADEMIC_RANK'

Line 1536: ,per_shared_types pst1

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
1539: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
1540: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

Line 1843: ,per_shared_types pst

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
1847: AND peo.person_id = ppet.person_id

Line 1844: ,per_shared_types pst1

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
1847: AND peo.person_id = ppet.person_id
1848: AND ppet.information_type = 'PQH_TENURE_STATUS'

Line 2075: ,per_shared_types pst

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
2079: AND peo.current_employee_flag = 'Y'

Line 2076: ,per_shared_types pst1

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
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'