DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on FF_FORMULAS_F

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

596: -- ----------------------------------------------------------------------------
597: --
598: -- Description:
599: -- This procedure is used to ensure that FORMULA_ID is present in
600: -- FF_FORMULAS_F as of session date and must be of type
601: -- 'ELEMENT INPUT VALIDATION'
602: --
603: -- ----------------------------------------------------------------------------
604: PROCEDURE chk_formula_id

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