APPS.PER_US_IPEDS_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 215: ,per_assignment_status_types ast

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
218: ,per_pay_bases ppb
219: ,per_people_extra_info ppea

Line 334: ,per_assignment_status_types ast

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
337: ,per_pay_bases ppb
338: ,per_people_extra_info ppea

Line 461: ,per_assignment_status_types ast

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
464: ,per_pay_bases ppb
465: WHERE peo.person_id = asg.person_id

Line 575: ,per_assignment_status_types ast

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
578: ,per_pay_bases ppb
579: ,per_people_extra_info ppea

Line 697: ,per_assignment_status_types ast

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
700: ,per_pay_bases ppb
701: WHERE peo.person_id = asg.person_id

Line 847: ,per_assignment_status_types ast

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
850: ,per_pay_bases ppb
851: ,per_people_extra_info ppet

Line 957: ,per_assignment_status_types ast

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
960: ,per_pay_bases ppb
961: ,per_people_extra_info ppet

Line 1074: ,per_assignment_status_types ast

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
1077: ,per_pay_bases ppb
1078: WHERE peo.person_id = asg.person_id

Line 1186: ,per_assignment_status_types ast

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
1189: ,per_pay_bases ppb
1190: ,per_contracts_f pco

Line 1300: ,per_assignment_status_types ast

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
1303: ,per_pay_bases ppb
1304: WHERE peo.person_id = asg.person_id

Line 1427: ,per_assignment_status_types ast

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
1430: ,per_pay_bases ppb
1431: WHERE peo.person_id = asg.person_id

Line 1529: ,per_assignment_status_types ast

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
1532: ,per_pay_bases ppb
1533: ,per_people_extra_info ppea

Line 1600: ,per_assignment_status_types ast

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
1603: ,per_pay_bases ppb
1604: WHERE peo.person_id = asg.person_id

Line 1725: ,per_assignment_status_types ast

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
1728: ,per_pay_bases ppb
1729: ,per_people_extra_info ppet

Line 1837: ,per_assignment_status_types ast

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
1840: ,per_pay_bases ppb
1841: ,per_people_extra_info ppet

Line 1957: ,per_assignment_status_types ast

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
1960: ,per_pay_bases ppb
1961: ,per_periods_of_service pps

Line 2070: ,per_assignment_status_types ast

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
2073: ,per_pay_bases ppb
2074: ,per_contracts_f pco

Line 2185: ,per_assignment_status_types ast

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
2188: ,per_pay_bases ppb
2189: ,per_periods_of_service pps

Line 2292: ,per_assignment_status_types ast

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
2295: ,per_pay_bases ppb
2296: ,per_periods_of_service pps

Line 2427: ,per_assignment_status_types ast

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
2430: ,per_pay_bases ppb
2431: WHERE peo.person_id = asg.person_id