[Home] [Help]
372: --checks would anyway get the latest payroll details
373:
374: select count(*)
375: into v_count
376: from pay_all_payrolls_f pap,
377: hr_soft_coding_keyflex scl
378: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)
379: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
380: and scl.segment8 = p_irp5no
374: select count(*)
375: into v_count
376: from pay_all_payrolls_f pap,
377: hr_soft_coding_keyflex scl
378: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)
379: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
380: and scl.segment8 = p_irp5no
381: and to_date(v_tax_end_date,'DD-MM-YYYY') between pap.effective_start_date and pap.effective_end_date;
382: if v_count > 1 then
1800: l_sort_order1 varchar2(30);
1801: l_sort_order2 varchar2(30);
1802: l_sort_order3 varchar2(30);
1803: l_legal_entity varchar2(240);
1804: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1805: l_proc varchar2(250):='PAY_ZA_EOY_VAL.GET_TYEV_PARAMETERS';
1806: begin
1807: -- Retrieve the Report Parameter Information
1808:
1832: from pay_payrolls_f ppf
1833: where ppf.payroll_id=P_PAYROLL_ID
1834: and ppf.effective_start_date =
1835: (select max(effective_start_date)
1836: from pay_all_payrolls_f ppf1
1837: where ppf1.payroll_id=ppf.payroll_id
1838: and P_TAX_YEAR_END between ppf1.effective_start_date and ppf1.effective_end_date);
1839: end if;
1840:
3760:
3761: cursor csr_payrolls (l_tax_year number)
3762: IS
3763: select distinct payroll_id
3764: from pay_all_payrolls_f papf
3765: where business_group_id = P_BUSINESS_GROUP_ID
3766: and exists ( select ''
3767: from per_time_periods ptp2
3768: where ptp2.prd_information1=l_tax_year