161: SELECT ppf.first_name, ppf.last_name, ppf.middle_names, ppf.order_name,
162: ppf.full_name, ppf.national_identifier,
163: ppf.employee_number
164: FROM per_assignments_f paf,
165: per_all_people_f ppf,
166: per_periods_of_service pps
167: WHERE paf.person_id = ppf.person_id
168: and paf.assignment_id = p_assignment_id
169: and p_effective_date between paf.effective_start_date
190: and pp.effective_end_date;
191:
192:
193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
191:
192:
193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
192:
193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
200: lv_employee_number per_all_people_f.employee_number%TYPE;
193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
200: lv_employee_number per_all_people_f.employee_number%TYPE;
201: ln_business_group_id number;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
200: lv_employee_number per_all_people_f.employee_number%TYPE;
201: ln_business_group_id number;
202: ln_per_pay_method number;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
200: lv_employee_number per_all_people_f.employee_number%TYPE;
201: ln_business_group_id number;
202: ln_per_pay_method number;
203: ln_pre_pay_id number;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;
198: lv_full_name per_all_people_f.full_name%TYPE;
199: lv_national_identifier per_all_people_f.national_identifier%TYPE;
200: lv_employee_number per_all_people_f.employee_number%TYPE;
201: ln_business_group_id number;
202: ln_per_pay_method number;
203: ln_pre_pay_id number;
204: ln_prepay_asg_act number;