DBA Data[Home] [Help]

APPS.PAY_ETP_BUS_ND dependencies on FF_FORMULA_TYPES

Line 879: from ff_formulas_f fml, ff_formula_types ftp

875: l_exists varchar2(1);
876: Cursor c_chk_formula_type
877: is
878: select '1'
879: from ff_formulas_f fml, ff_formula_types ftp
880: where fml.formula_id = p_formula_id
881: and p_effective_date between fml.effective_start_date
882: and fml.effective_end_date
883: and ftp.formula_type_id = fml.formula_type_id

Line 2036: l_formula_type ff_formula_types.formula_type_name%type;

2032: ,p_validation_end_date in date
2033: ) is
2034: --
2035: l_proc varchar2(72) := g_package||'chk_iterative_rules';
2036: l_formula_type ff_formula_types.formula_type_name%type;
2037:
2038: Cursor c_formula_type
2039: is
2040: select formula_type_name

Line 2041: from ff_formula_types ftp, ff_formulas_f fml

2037:
2038: Cursor c_formula_type
2039: is
2040: select formula_type_name
2041: from ff_formula_types ftp, ff_formulas_f fml
2042: where fml.formula_id = p_iterative_formula_id
2043: and p_effective_date between fml.effective_start_date
2044: and fml.effective_end_date
2045: and ftp.formula_type_id = fml.formula_type_id;