283: CURSOR c_job_role_formula IS
284: SELECT fff.formula_id
285: FROM
286: ff_formulas_f fff 287: ,ff_formula_types fft 288: WHERE fft.formula_type_name = 'QuickPaint'
289: AND fff.formula_type_id = fft.formula_type_id
290: AND fff.business_group_id = p_business_group_id
291: AND p_date BETWEEN fff.effective_start_date AND fff.effective_end_date