DBA Data[Home] [Help]

APPS.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on FND_FLEX_VALUES_VL

Line 1290: fnd_flex_values_vl

1286: is
1287: SELECT
1288: FLEX_VALUE_ID, FLEX_VALUE, DESCRIPTION
1289: from
1290: fnd_flex_values_vl
1291: -- 4872820 18-Oct-2006 Start-1
1292: --WHERE flex_value_set_id= fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');
1293: WHERE FLEX_VALUE_SET_ID = m_acc_value_set_id AND ENABLED_FLAG = 'Y'
1294: -- 4872820 18-Oct-2006 End-1

Line 1320: fnd_flex_values_vl where

1316: (m_child_flex_value varchar2, m_acc_value_set_id number) is
1317: SELECT
1318: FLEX_VALUE_ID, FLEX_VALUE, DESCRIPTION
1319: from
1320: fnd_flex_values_vl where
1321: FLEX_VALUE = m_child_flex_value
1322: -- 4872820 18-Oct-2006 Start-2
1323: -- and FLEX_VALUE_SET_ID = fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');
1324: AND FLEX_VALUE_SET_ID = m_acc_value_set_id AND ENABLED_FLAG = 'Y'