Line 545: from ff_formulas_f ff, ff_formula_types ft
541: ) IS
542:
543: cursor csr_formula is
544: select 'X' 545: from ff_formulas_f ff, ff_formula_types ft 546: where nvl(ff.legislation_code,nvl(p_legislation_code,'~~nvl~~'))
547: = nvl(p_legislation_code,'~~nvl~~')
548: and nvl(ff.business_group_id, nvl(p_business_group_id,-1))=nvl(p_business_group_id,-1)
549: and p_effective_date between ff.effective_start_date and ff.effective_end_date