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.

[Home] [Help]

APPS.PER_US_IPEDS_PKG dependencies on PQH_INST_TYPE_PKG

Line 212: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

208: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
209: ,ppet.pei_information1 tenure_status
210: ,ppea.pei_information1 academic_rank
211: ,peo.person_id
212: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
213: FROM per_all_people_f peo
214: ,per_all_assignments_f asg
215: ,per_assignment_status_types ast
216: ,per_jobs job

Line 331: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

327: ,ppet.pei_information1 tenure_status
328: ,ppea.pei_information1 academic_rank
329: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
330: ,peo.person_id
331: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
332: FROM per_all_people_f peo
333: ,per_all_assignments_f asg
334: ,per_assignment_status_types ast
335: ,per_jobs job

Line 458: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

454: SELECT peo.sex gender
455: ,job.job_information8 ipeds_category
456: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
457: ,peo.person_id
458: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
459: FROM per_all_people_f peo
460: ,per_all_assignments_f asg
461: ,per_assignment_status_types ast
462: ,per_jobs job

Line 572: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

568: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
569: ,ppea.pei_information1 academic_rank
570: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
571: ,peo.person_id
572: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
573: FROM per_all_people_f peo
574: ,per_all_assignments_f asg
575: ,per_assignment_status_types ast
576: ,per_jobs job

Line 694: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

690: SELECT peo.sex gender
691: ,job.job_information8 ipeds_category
692: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
693: ,peo.person_id
694: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
695: FROM per_all_people_f peo
696: ,per_all_assignments_f asg
697: ,per_assignment_status_types ast
698: ,per_jobs job

Line 844: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

840: ,job.job_information8 ipeds_category
841: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
842: ,ppet.pei_information1 tenure_status
843: ,peo.person_id
844: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
845: FROM per_all_people_f peo
846: ,per_all_assignments_f asg
847: ,per_assignment_status_types ast
848: ,per_jobs job

Line 954: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

950: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
951: ,ppet.pei_information1 tenure_status
952: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
953: ,peo.person_id
954: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
955: FROM per_all_people_f peo
956: ,per_all_assignments_f asg
957: ,per_assignment_status_types ast
958: ,per_jobs job

Line 1070: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

1066: FROM (
1067: SELECT peo.sex gender
1068: ,job.job_information8 ipeds_category
1069: ,peo.person_id person_id
1070: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
1071: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1072: FROM per_all_people_f peo
1073: ,per_all_assignments_f asg
1074: ,per_assignment_status_types ast

Line 1183: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

1179: ,job.job_information8 ipeds_category
1180: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1181: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
1182: ,peo.person_id
1183: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
1184: FROM per_all_people_f peo
1185: ,per_all_assignments_f asg
1186: ,per_assignment_status_types ast
1187: ,per_jobs job

Line 1296: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type

1292: FROM (
1293: SELECT peo.sex gender
1294: ,job.job_information8 ipeds_category
1295: ,peo.person_id person_id
1296: ,pqh_inst_type_pkg.get_inst_type(asg.organization_id) org_med_type
1297: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1298: FROM per_all_people_f peo
1299: ,per_all_assignments_f asg
1300: ,per_assignment_status_types ast