[Home] [Help]
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
217: ,per_pay_proposals ppp
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
336: ,per_pay_proposals ppp
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
463: ,per_pay_proposals ppp
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
577: ,per_pay_proposals ppp
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
699: ,per_pay_proposals ppp
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
849: ,per_pay_proposals ppp
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
959: ,per_pay_proposals ppp
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
1076: ,per_pay_proposals ppp
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
1188: ,per_pay_proposals ppp
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
1302: ,per_pay_proposals ppp
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
1428: ,per_jobs job
1429: ,per_pay_proposals ppp
1523: ,ppea.pei_information1 academic_rank
1524: ,peo.person_id
1525: ,CEIL(pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date)) cont_dur_mon
1526: ,(NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) annual_sal
1527: FROM per_all_people_f peo
1528: ,per_all_assignments_f asg
1529: ,per_assignment_status_types ast
1530: ,per_jobs job
1531: ,per_pay_proposals ppp
1594: one code 27. In XML meaning would be changed accordingly*/
1595: ,DECODE(job.job_information8,28,27,29,27,30,27,job.job_information8) ipeds_category
1596: ,COUNT(peo.person_id)
1597: ,SUM((NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor)) annual_sal
1598: FROM per_all_people_f peo
1599: ,per_all_assignments_f asg
1600: ,per_assignment_status_types ast
1601: ,per_jobs job
1602: ,per_pay_proposals ppp
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
1725: ,per_assignment_status_types ast
1726: ,per_jobs job
1727: ,per_pay_proposals ppp
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
1836: ,per_all_assignments_f asg
1837: ,per_assignment_status_types ast
1838: ,per_jobs job
1839: ,per_pay_proposals ppp
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
1958: ,per_jobs job
1959: ,per_pay_proposals ppp
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
2070: ,per_assignment_status_types ast
2071: ,per_jobs job
2072: ,per_pay_proposals ppp
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
2186: ,per_jobs job
2187: ,per_pay_proposals ppp
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
2293: ,per_jobs job
2294: ,per_pay_proposals ppp
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
2428: ,per_jobs job
2429: ,per_pay_proposals ppp