[Home] [Help]
109: l_payroll_id BINARY_INTEGER;
110: BEGIN
111: SELECT pay.payroll_id
112: INTO l_payroll_id
113: FROM pay_payrolls_f pay
114: WHERE pay.payroll_name = p_payroll_name
115: AND pay.business_group_id + 0 = p_business_group_id
116: AND p_effective_date BETWEEN
117: pay.effective_start_date AND pay.effective_end_date;