APPS.PAY_STATUS_RULES_PKG dependencies on FF_FDI_USAGES_F

Line 378: (select item_name from ff_fdi_usages_f

374: where iv_tl.input_value_id = iv.input_value_id
375: and iv.element_type_id = p_element_type_id
376: and userenv('LANG') = iv_tl.language
377: and translate(upper(iv_tl.name),' ','_') in
378: (select item_name from ff_fdi_usages_f
379: where formula_id = p_formula_id);
380:
381: cursor csr_matching_data_types is
382: select count(fdi.formula_id)

Line 385: ff_fdi_usages_f FDI

381: cursor csr_matching_data_types is
382: select count(fdi.formula_id)
383: from pay_input_values_f_tl IV_TL,
384: pay_input_values_f IV,
385: ff_fdi_usages_f FDI
386: where iv_tl.input_value_id = iv.input_value_id
387: and fdi.formula_id = p_formula_id
388: and userenv('LANG') = iv_tl.language
389: and fdi.usage in ( 'I', 'B' ) -- either input or in/output item