APPS.JA_CN_SYSOPS_BANK_PKG dependencies on FND_FLEX_VALUE_SETS

Line 225: FROM FND_FLEX_VALUE_SETS ffs,

221: pipelined IS
222: --assigned bsv
223: CURSOR CUR_BSV IS
224: SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffv.FLEX_VALUE_SET_ID
225: FROM FND_FLEX_VALUE_SETS ffs,
226: FND_FLEX_VALUES_VL ffv,
227: GL_LEGAL_ENTITIES_BSVS gleb
228: WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
229: AND ffs.flex_value_set_id = gleb.flex_value_set_id

Line 243: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv

239: AND gleb.legal_entity_id = p_legal_id;
240: --non assigned bsv
241: CURSOR CUR_NON_BSV(c_flex_value_set_id pls_integer) IS
242: SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffv.FLEX_VALUE_SET_ID
243: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv
244: WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
245: AND SUMMARY_FLAG = 'N'
246: AND ENABLED_FLAG = 'Y'
247: AND trunc(nvl(START_DATE_ACTIVE, sysdate), 'DD') <=

Line 395: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv

391:
392: --get bsv summary
393: SELECT SUMMARY_FLAG
394: INTO l_summary
395: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv
396: WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
397: AND ffv.FLEX_VALUE_SET_ID = l_flex_valueset_id
398: AND ffv.FLEX_VALUE = l_bsv_temp;
399: