APPS.FF_EXEC dependencies on FF_FORMULAS_F

Line 99: * info from ff_formulas_f and ff_compiled_info_f.

95: /*
96: * The Fast Formula cache types.
97: * The cache consists of the following things:
98: * 1) A table of records that is essentially a combination of
99: * info from ff_formulas_f and ff_compiled_info_f.
100: * The formula cache size is limited, and is controlled by
101: * an internal variable. It defaults to FF_DFLT_CACHE_SIZE.
102: * In addition, a table of records that holds information derived
103: * from the ff_fdi_usages_f table.

Line 1253: ff_formulas_f i.e. p_legislation_code must not be derived from

1249: DESCRIPTION
1250: Fetches the route_id given a database item name.
1251: NOTES
1252: p_business_group_id and p_legislation_code must come direct from
1253: ff_formulas_f i.e. p_legislation_code must not be derived from
1254: p_business_group_id.
1255: */
1256: function dbi2route_id
1257: (p_formula_name in varchar2

Line 1441: l_formula_name ff_formulas_f.formula_name%type;

1437: order by 6, fdiu.item_name; -- *** IMPORTANT.
1438:
1439: l_effective_start_date date;
1440: l_effective_end_date date;
1441: l_formula_name ff_formulas_f.formula_name%type;
1442: l_fdiu_entry_count ff_compiled_info_f.fdiu_entry_count%type;
1443: l_package_name varchar2(60);
1444: l_first_fdiu binary_integer;
1445: l_fdiu_row binary_integer; -- latest fdiu row.

Line 1503: from ff_formulas_f fff,

1499: l_formula_name,
1500: l_business_group_id,
1501: l_legislation_code,
1502: l_fdiu_entry_count
1503: from ff_formulas_f fff,
1504: ff_compiled_info_f fci
1505: where fff.formula_id = p_formula_id
1506: and p_effective_date between
1507: fff.effective_start_date and fff.effective_end_date