Line 613: from ff_formulas_f ff, ff_formula_types ft
609: ) IS
610:
611: cursor csr_formula is
612: select 'X' 613: from ff_formulas_f ff, ff_formula_types ft 614: where nvl(ff.legislation_code,nvl(p_legislation_code,'~~nvl~~'))
615: = nvl(p_legislation_code,'~~nvl~~')
616: and nvl(ff.business_group_id, nvl(p_business_group_id,-1))=nvl(p_business_group_id,-1)
617: and p_effective_date between ff.effective_start_date and ff.effective_end_date