[Home] [Help]
2512: cursor csr_get_asg_num is
2513: select paaf.assignment_number,
2514: paaf.assignment_id,
2515: nvl(papf.per_information10,'N')
2516: from per_assignment_extra_info paei,
2517: per_all_assignments_f paaf,
2518: per_assignment_status_types pat,
2519: per_all_people_f papf
2520: where paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
2580: --check all the assignments in this PAYE ref have RTI Payroll id.
2581: for asg_rec in csr_asg
2582: loop
2583: begin
2584: select 1 into l_pay_id_found from per_assignment_extra_info paei where assignment_id = asg_rec.assignment_id
2585: and paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION' and paei.AEI_INFORMATION3 is not null;
2586: exception
2587: when no_data_found then
2588: l_msg := 'Payroll id for one of the aggregated assignments not present for supplied Payroll ID:'|| p_m34_rec.assignment_number;
2618: --check all the assignments in this PAYE ref have RTI Payroll id.
2619: for asg_rec in csr_asg
2620: loop
2621: begin
2622: select 1 into l_pay_id_found from per_assignment_extra_info paei where assignment_id = asg_rec.assignment_id
2623: and paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION' and paei.AEI_INFORMATION3 is not null;
2624: exception
2625: when no_data_found then
2626: l_msg := 'Payroll id for one of the aggregated assignments not present for supplied Payroll ID:'|| p_m34_rec.assignment_number;