2913: l_payroll_id number;
2914: begin
2915: select pay.payroll_id
2916: into l_payroll_id 2917: from pay_payrolls_f pay 2918: where pay.payroll_name = p_payroll_name
2919: and pay.business_group_id + 0 = p_business_group_id
2920: and p_effective_date between
2921: pay.effective_start_date and pay.effective_end_date;