DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on FF_FORMULAS_F

Line 301: l_formula_id ff_formulas_f.formula_id%TYPE;

297: procedure spawn_archive_reports
298: is
299: l_count number :=0;
300: ps_request_id NUMBER;
301: l_formula_id ff_formulas_f.formula_id%TYPE;
302: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
303: l_sort_order1 varchar2(40);
304: l_sort_order2 varchar2(40):=null;
305: l_sort_order3 varchar2(40):=null;

Line 326: FROM ff_formulas_f a,

322:
323:
324: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS
325: SELECT a.formula_id
326: FROM ff_formulas_f a,
327: ff_formula_types t
328: WHERE a.formula_name = p_formula_name
329: AND business_group_id IS NULL
330: AND legislation_code = 'AU'