2886: l_payroll_id number;
2887: begin
2888: select pay.payroll_id
2889: into l_payroll_id 2890: from pay_payrolls_f pay 2891: where pay.payroll_name = p_payroll_name
2892: and pay.business_group_id + 0 = p_business_group_id
2893: and p_effective_date between
2894: pay.effective_start_date and pay.effective_end_date;