DBA Data[Home] [Help]

APPS.JA_CN_PS_SI_SM_EXPORT_PKG dependencies on FND_FLEX_VALUE_SETS

Line 65: FROM fnd_flex_values_vl ffv, fnd_flex_value_sets ffvs

61: pn_account_year NUMBER) IS
62: SELECT DISTINCT settlement_method_number, settlement_method_name
63: FROM (SELECT ffv.flex_value settlement_method_number,
64: ffv.description settlement_method_name
65: FROM fnd_flex_values_vl ffv, fnd_flex_value_sets ffvs
66: WHERE ffv.flex_value_set_id = ffvs.flex_value_set_id
67: AND ffvs.flex_value_set_name = 'JA_CN_SETTLEMENT_METHOD')
68: --Only existing settlement method in Itemized Journal table should be exported
69: WHERE settlement_method_number IN