133: -- as 'APAC ELEMENTS'.
134: ********************************************************************************/
135:
136: PROCEDURE archive_kr_standard_elements
137: (p_pre_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
138: ,p_pre_effective_date IN DATE
139: ,p_arch_assignment_action_id IN NUMBER)
140: IS
141:
224: ,pap.accrual_units_of_measure accrual_units_of_measure
225: ,hoi.org_information13 leave_taken_dim
226: ,pac.assignment_id
227: FROM pay_accrual_plans pap
228: ,pay_assignment_actions pac
229: ,pay_payroll_actions ppa
230: ,hr_organization_information hoi
231: ,pay_element_links_f pel
232: ,pay_element_entries_f pee
708: paa_run.payroll_action_id run_payroll_action_id,
709: ppa_run.payroll_id payroll_id,
710: ppa_run.run_type_id run_type_id,
711: paa_run.tax_unit_id tax_unit_id
712: FROM pay_assignment_actions paa_arch_chd,
713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
709: ppa_run.payroll_id payroll_id,
710: ppa_run.run_type_id run_type_id,
711: paa_run.tax_unit_id tax_unit_id
712: FROM pay_assignment_actions paa_arch_chd,
713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
710: ppa_run.run_type_id run_type_id,
711: paa_run.tax_unit_id tax_unit_id
712: FROM pay_assignment_actions paa_arch_chd,
713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
712: FROM pay_assignment_actions paa_arch_chd,
713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,
720: per_time_periods ptp
734: AND ppa_run.date_earned between ptp.start_date
735: AND ptp.end_date
736: -- Get the highest in sequence for this payslip
737: AND paa_run.action_sequence = (SELECT max(paa_run2.action_sequence)
738: FROM pay_assignment_actions paa_run2,
739: pay_action_interlocks pai_run2
740: WHERE pai_run2.locking_action_id =
741: paa_arch_chd.assignment_action_id
742: AND pai_run2.locked_action_id =
751: FROM per_time_periods ptp
752: ,pay_payroll_actions ppa
753: WHERE ptp.payroll_id = ppa.payroll_id
754: AND ppa.payroll_action_id = ( SELECT payroll_action_id
755: FROM pay_assignment_actions
756: WHERE assignment_action_id =p_assignment_action_id)
757: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;
758:
759: -- Bug 5600114
761: IS
762: SELECT pps.actual_termination_date
763: FROM per_all_assignments_f paf,
764: per_periods_of_service pps,
765: pay_assignment_actions paa,
766: per_time_periods ptp,
767: pay_payroll_actions ppa
768: WHERE paa.assignment_action_id = p_assignment_action_id
769: AND ptp.payroll_id = ppa.payroll_id