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_US_HR_UTILITY_PKG

Line 208: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

204: ,ipeds_category
205: FROM(
206: SELECT peo.sex gender
207: ,job.job_information8 ipeds_category
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

Line 326: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

322: ,ipeds_category
323: FROM (
324: SELECT peo.sex gender
325: ,job.job_information8 ipeds_category
326: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
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

Line 456: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

452: ,ipeds_category
453: FROM (
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

Line 568: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

564: ,ipeds_category
565: FROM (
566: SELECT peo.sex gender
567: ,job.job_information8 ipeds_category
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

Line 692: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

688: ,ipeds_category
689: FROM (
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

Line 841: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

837: ,ipeds_category
838: FROM (
839: SELECT peo.sex gender
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

Line 950: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

946: ,ipeds_category
947: FROM (
948: SELECT peo.sex gender
949: ,job.job_information8 ipeds_category
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

Line 1071: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

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
1075: ,per_jobs job

Line 1180: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

1176: ,ipeds_category
1177: FROM (
1178: SELECT peo.sex gender
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

Line 1297: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

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
1301: ,per_jobs job

Line 1423: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

1419: ,DECODE(ipeds_code,21,21,22,21,23,21,24,21,ipeds_code) ipeds_category
1420: FROM (
1421: SELECT peo.sex gender
1422: ,job.job_information8 ipeds_code
1423: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1424: ,peo.person_id
1425: FROM per_all_people_f peo
1426: ,per_all_assignments_f asg
1427: ,per_assignment_status_types ast

Line 1720: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

1716: ,ipeds_category
1717: FROM (
1718: SELECT peo.sex gender
1719: ,job.job_information8 ipeds_category
1720: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1721: ,ppet.pei_information1 tenure_status
1722: ,peo.person_id
1723: FROM per_all_people_f peo
1724: ,per_all_assignments_f asg

Line 1831: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

1827: ,ipeds_category
1828: FROM (
1829: SELECT peo.sex gender
1830: ,job.job_information8 ipeds_category
1831: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1832: ,ppet.pei_information1 tenure_status
1833: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
1834: ,peo.person_id
1835: FROM per_all_people_f peo

Line 1953: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

1949: ,ipeds_category
1950: FROM (
1951: SELECT peo.sex gender
1952: ,job.job_information8 ipeds_category
1953: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
1954: ,peo.person_id
1955: FROM per_all_people_f peo
1956: ,per_all_assignments_f asg
1957: ,per_assignment_status_types ast

Line 2065: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

2061: ,ipeds_category
2062: FROM (
2063: SELECT peo.sex gender
2064: ,job.job_information8 ipeds_category
2065: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
2066: ,pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) cont_dur_mon
2067: ,peo.person_id
2068: FROM per_all_people_f peo
2069: ,per_all_assignments_f asg

Line 2181: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

2177: ,ipeds_category
2178: FROM (
2179: SELECT peo.sex gender
2180: ,job.job_information8 ipeds_category
2181: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
2182: ,peo.person_id
2183: FROM per_all_people_f peo
2184: ,per_all_assignments_f asg
2185: ,per_assignment_status_types ast

Line 2288: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

2284: FROM (SELECT peo.sex gender
2285: /* As We have to report categories 27,28,29,30 into one so changed the codes to
2286: one code 27. In XML meaning would be changed accordingly*/
2287: ,DECODE(job.job_information8,27,27,28,27,29,27,30,27,job.job_information8) ipeds_category
2288: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
2289: ,peo.person_id
2290: FROM per_all_people_f peo
2291: ,per_all_assignments_f asg
2292: ,per_assignment_status_types ast

Line 2423: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code

2419: category and 27,28,29,30 into one so changed the codes to
2420: one code 21 and 27 respectively. In XML meaning would be
2421: changed accordingly */
2422: ,DECODE(job.job_information8,21,21,22,21,23,21,24,21,25,21,26,21,27,27,28,27,29,27,job.job_information8) ipeds_category
2423: ,per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id,p_report_date,'Y') ethnic_code
2424: ,peo.person_id
2425: FROM per_all_people_f peo
2426: ,per_all_assignments_f asg
2427: ,per_assignment_status_types ast