[Home] [Help]
580: AND c_reporting_date BETWEEN paa.effective_start_date
581: AND paa.effective_end_date;
582: --
583: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
584: l_actid pay_assignment_actions.assignment_action_id%TYPE;
585: l_unused_number NUMBER;
586: l_action_info_id pay_action_information.action_information_id%TYPE;
587: l_ovn pay_action_information.object_version_number%TYPE;
588: l_contract_start_date DATE;
637: FETCH csr_filter_legal_employer INTO l_assignment_id,l_legal_employer;
638:
639: IF csr_filter_legal_employer%FOUND THEN
640:
641: SELECT pay_assignment_actions_s.NEXTVAL
642: INTO l_actid
643: FROM dual;
644:
645: hr_nonrun_asact.insact(l_actid
1485: ,pai.action_context_id action_context_id
1486: ,pai.action_information1 action_status
1487: ,max(pai.effective_date) current_reporting_date
1488: FROM pay_payroll_actions ppa
1489: ,pay_assignment_actions paa
1490: ,per_all_assignments_f asg_run
1491: ,pay_action_information pai
1492: WHERE ppa.payroll_action_id = c_payroll_action_id
1493: AND paa.payroll_action_id = ppa.payroll_action_id
1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;
1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;
1522: l_ovn pay_action_information.object_version_number%TYPE;
1523: l_unused_number NUMBER;
1524: l_effective_start_date DATE;
1532: FOR qualifying_assignments IN csr_get_assignments (g_arch_payroll_action_id) LOOP
1533: --
1534: -- create a new action and lock the fetched one
1535: --
1536: SELECT pay_assignment_actions_s.NEXTVAL
1537: INTO l_actid
1538: FROM dual;
1539: --
1540: hr_nonrun_asact.insact(l_actid