APPS.PER_US_IPEDS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 219: ,per_people_extra_info ppea

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
222: AND peo.person_id = ppea.person_id
223: AND peo.person_id = ppet.person_id

Line 220: ,per_people_extra_info ppet

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
222: AND peo.person_id = ppea.person_id
223: AND peo.person_id = ppet.person_id
224: AND ppea.information_type = 'PQH_ACADEMIC_RANK'

Line 338: ,per_people_extra_info ppea

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
341: ,per_shared_types pst
342: ,per_shared_types pst1

Line 339: ,per_people_extra_info ppet

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

Line 493: FROM per_people_extra_info ppet

489: FROM hr_all_organization_units hou
490: WHERE hou.business_group_id = p_business_group_id
491: AND hou.organization_id = asg.organization_id)
492: AND NOT EXISTS (SELECT 'Y'
493: FROM per_people_extra_info ppet
494: WHERE ppet.person_id = peo.person_id
495: AND ppet.information_type = 'PQH_TENURE_STATUS')
496: )
497: GROUP BY '4'

Line 579: ,per_people_extra_info ppea

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

Line 851: ,per_people_extra_info ppet

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
854: AND ppet.information_type = 'PQH_TENURE_STATUS'
855: AND ppet.pei_information1 IN ('01','02','04')

Line 961: ,per_people_extra_info ppet

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

Line 1106: FROM per_people_extra_info ppet

1102: FROM hr_all_organization_units hou
1103: WHERE hou.business_group_id = p_business_group_id
1104: AND hou.organization_id = asg.organization_id)
1105: AND NOT EXISTS( SELECT 'Y'
1106: FROM per_people_extra_info ppet
1107: WHERE ppet.person_id = peo.person_id
1108: AND ppet.information_type = 'PQH_TENURE_STATUS')
1109: )
1110: GROUP BY '04'

Line 1533: ,per_people_extra_info ppea

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

Line 1729: ,per_people_extra_info ppet

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

Line 1841: ,per_people_extra_info ppet

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
1844: ,per_shared_types pst1
1845: ,per_periods_of_service pps

Line 1992: FROM per_people_extra_info ppet

1988: FROM hr_all_organization_units hou
1989: WHERE hou.business_group_id = p_business_group_id
1990: AND hou.organization_id = asg.organization_id)
1991: AND NOT EXISTS (SELECT 'Y'
1992: FROM per_people_extra_info ppet
1993: WHERE ppet.person_id = peo.person_id
1994: AND ppet.information_type = 'PQH_TENURE_STATUS')
1995: )
1996: GROUP BY '4'