207: CURSOR get_payroll_id( cp_bg_id number
208: ,cp_payroll_name varchar2
209: ,cp_eff_date date) IS
210: SELECT payroll_id
211: FROM pay_payrolls_f
212: WHERE business_group_id + 0 = cp_bg_id
213: AND payroll_name = cp_payroll_name
214: AND cp_eff_date between effective_start_date and effective_end_date;
215: