603: , ppf.middle_names
604: , ppf.title
605: , paf.assignment_number
606: FROM per_all_assignments_f paf
607: , per_all_people_f ppf
608: , per_periods_of_service pps
609: , per_jobs pj
610: , hr_organization_units hou
611: , pay_payrolls_f prl
703: and ppa_chq.effective_date between popm.effective_start_date and popm.effective_end_date;
704:
705:
706: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;
707: l_first_name per_all_people_f.first_name%TYPE;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
704:
705:
706: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;
707: l_first_name per_all_people_f.first_name%TYPE;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
705:
706: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;
707: l_first_name per_all_people_f.first_name%TYPE;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
706: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;
707: l_first_name per_all_people_f.first_name%TYPE;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
714: l_title per_all_people_f.title%TYPE;
707: l_first_name per_all_people_f.first_name%TYPE;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
714: l_title per_all_people_f.title%TYPE;
715: l_assignment_id NUMBER;
708: l_last_name per_all_people_f.last_name%TYPE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
714: l_title per_all_people_f.title%TYPE;
715: l_assignment_id NUMBER;
716: l_effective_date DATE;
709: l_order_name per_all_people_f.order_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
714: l_title per_all_people_f.title%TYPE;
715: l_assignment_id NUMBER;
716: l_effective_date DATE;
717: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
710: l_full_name per_all_people_f.full_name%TYPE;
711: l_national_identifier per_all_people_f.national_identifier%TYPE;
712: l_employee_number per_all_people_f.employee_number%TYPE;
713: l_middle_names per_all_people_f.middle_names%TYPE;
714: l_title per_all_people_f.title%TYPE;
715: l_assignment_id NUMBER;
716: l_effective_date DATE;
717: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
718: l_job per_jobs.name%TYPE;