[Home] [Help]
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
220: ,per_people_extra_info ppet
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
339: ,per_people_extra_info ppet
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
466: AND peo.current_employee_flag = 'Y'
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
580: ,per_contracts_f pco
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
702: AND peo.current_employee_flag = 'Y'
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
852: WHERE peo.person_id = asg.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
962: ,per_contracts_f pco
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
1079: AND peo.current_employee_flag = 'Y'
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
1191: ,per_shared_types pst
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
1305: AND peo.current_employee_flag = 'Y'
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
1432: AND peo.current_employee_flag = 'Y'
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
1534: ,per_contracts_f pco
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
1605: AND peo.current_employee_flag = 'Y'
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
1730: ,per_periods_of_service pps
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
1842: ,per_contracts_f pco
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
1962: WHERE peo.person_id = asg.person_id
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
2075: ,per_shared_types pst
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
2190: WHERE peo.person_id = asg.person_id
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
2297: WHERE peo.person_id = asg.person_id
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
2432: AND peo.current_employee_flag = 'Y'