APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on FF_FORMULAS_F

Line 386: ff_formulas_f ff

382: FROM pay_user_column_instances_f cinst,
383: pay_user_columns c,
384: pay_user_rows_f r,
385: pay_user_tables tab,
386: ff_formulas_f ff
387: WHERE tab.user_table_id = p_table_id AND c.user_table_id = tab.user_table_id
388: AND NVL(c.business_group_id, p_bus_group_id) = p_bus_group_id AND NVL(c.legislation_code, 'GB') =
389: 'GB'
390: AND UPPER(c.user_column_name) = UPPER(p_col_name) AND cinst.user_column_id = c.user_column_id

Line 1157: l_formula_id ff_formulas_f.formula_id%TYPE;

1153: from per_all_assignments_f
1154: where assignment_id = p_assignment_id;
1155:
1156: l_element_name pay_element_types_f.element_name%TYPE;
1157: l_formula_id ff_formulas_f.formula_id%TYPE;
1158: l_formula_effective_start_date DATE;
1159: l_inputs ff_exec.inputs_t;
1160: l_user_inputs ff_exec.inputs_t;
1161: l_outputs ff_exec.outputs_t;