DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on FF_FORMULAS_F

Line 532: -- FF_FORMULAS_F as of session date and must be of type

528: -- ----------------------------------------------------------------------------
529: --
530: -- Description:
531: -- This procedure is used to ensure that FORMULA_ID is present in
532: -- FF_FORMULAS_F as of session date and must be of type
533: -- 'ELEMENT INPUT VALIDATION'
534: --
535: -- ----------------------------------------------------------------------------
536: PROCEDURE chk_formula_id

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