DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_FORMULAS_F

Line 414: from ff_formulas_f f,

410: FUNCTION get_p45_formula_id RETURN NUMBER IS
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: --

Line 4056: l_formula_id ff_formulas_f.formula_id%TYPE;

4052: l_report_short_name VARCHAR2(20);
4053: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
4054: l_number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
4055: l_request_id NUMBER:=-1;
4056: l_formula_id ff_formulas_f.formula_id%TYPE;
4057: --
4058: l_print_together VARCHAR2(80);
4059: l_print_return BOOLEAN;
4060: l_stationary VARCHAR2(2); /*P45 A4 2008-09 changes */

Line 4068: FROM ff_formulas_f a,

4064:
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'