DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_FORMULAS_F

Line 366: from ff_formulas_f f,

362: FUNCTION get_p45_formula_id RETURN NUMBER IS
363:
364: cursor c_formula is
365: select f.FORMULA_ID
366: from ff_formulas_f f,
367: ff_formula_types t
368: where t.FORMULA_TYPE_ID = f.FORMULA_TYPE_ID
369: and f.FORMULA_NAME = 'P45';
370: --

Line 3364: l_formula_id ff_formulas_f.formula_id%TYPE;

3360: l_report_short_name VARCHAR2(20);
3361: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3362: l_number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
3363: l_request_id NUMBER:=-1;
3364: l_formula_id ff_formulas_f.formula_id%TYPE;
3365: --
3366: l_print_together VARCHAR2(80);
3367: l_print_return BOOLEAN;
3368: --

Line 3371: FROM ff_formulas_f a,

3367: l_print_return BOOLEAN;
3368: --
3369: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS
3370: SELECT a.formula_id
3371: FROM ff_formulas_f a,
3372: ff_formula_types t
3373: WHERE a.formula_name = p_formula_name
3374: AND business_group_id IS NULL
3375: AND legislation_code = 'GB'