DBA Data[Home] [Help]

APPS.PAY_ETP_BUS dependencies on FF_FORMULA_TYPES

Line 877: from ff_formulas_f fml, ff_formula_types ftp

873: l_exists varchar2(1);
874: Cursor c_chk_formula_type
875: is
876: select '1'
877: from ff_formulas_f fml, ff_formula_types ftp
878: where fml.formula_id = p_formula_id
879: and p_effective_date between fml.effective_start_date
880: and fml.effective_end_date
881: 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;