DBA Data[Home] [Help]

APPS.FA_DEPRN_TAX_REP_PKG dependencies on FND_FLEX_VALUES

Line 457: fnd_flex_values ffv,

453: p_state_from varchar2,
454: p_state_to varchar2) is
455: select ffv.flex_value
456: from fnd_flex_value_sets ffvs,
457: fnd_flex_values ffv,
458: fnd_flex_values_tl ffvt
459: where ffvs.flex_value_set_id = ffv.flex_value_set_id
460: and ffv.flex_value_id = ffvt.flex_value_id
461: and ffvs.flex_value_set_name = 'Vision FA State'

Line 458: fnd_flex_values_tl ffvt

454: p_state_to varchar2) is
455: select ffv.flex_value
456: from fnd_flex_value_sets ffvs,
457: fnd_flex_values ffv,
458: fnd_flex_values_tl ffvt
459: where ffvs.flex_value_set_id = ffv.flex_value_set_id
460: and ffv.flex_value_id = ffvt.flex_value_id
461: and ffvs.flex_value_set_name = 'Vision FA State'
462: and ffvt.language = 'US'