DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_FLEX_VALUES_TL

Line 870: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B

866: and language = userenv('LANG')
867: and flv.lookup_code = (substr(COMPILED_VALUE_ATTRIBUTES,
868: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,
869: to_char(nvl(b.START_DATE_ACTIVE,b.creation_date),'YYYYMMDD') START_DATE_ACTIVE,to_char(b.end_date_active,'YYYYMMDD') end_date_active
870: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
871: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
872: and T.LANGUAGE = userenv('LANG')
873: and substr(COMPILED_VALUE_ATTRIBUTES,
874: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,

Line 1049: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B

1045: and language = userenv('LANG')
1046: and flv.lookup_code = (substr(COMPILED_VALUE_ATTRIBUTES,
1047: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,
1048: to_char(nvl(b.START_DATE_ACTIVE,b.creation_date),'YYYYMMDD') START_DATE_ACTIVE,to_char(b.end_date_active,'YYYYMMDD') end_date_active
1049: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
1050: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
1051: and T.LANGUAGE = userenv('LANG')
1052: and substr(COMPILED_VALUE_ATTRIBUTES,
1053: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,