DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_FORMULA_TYPES

Line 415: ff_formula_types t

411:
412: cursor c_formula is
413: select f.FORMULA_ID
414: from ff_formulas_f f,
415: ff_formula_types t
416: where t.FORMULA_TYPE_ID = f.FORMULA_TYPE_ID
417: and f.FORMULA_NAME = 'P45';
418: --
419: l_formula_id NUMBER;

Line 4069: ff_formula_types t

4065: --
4066: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS
4067: SELECT a.formula_id
4068: FROM ff_formulas_f a,
4069: ff_formula_types t
4070: WHERE a.formula_name = p_formula_name
4071: AND business_group_id IS NULL
4072: AND legislation_code = 'GB'
4073: AND a.formula_type_id = t.formula_type_id