DBA Data[Home] [Help]

APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on DUAL

Line 228: FROM sys.dual;

224:
225: SELECT decode( nvl(p_txn_ext_attrib_vals_rec.preserve_detail_flag,fnd_api.g_miss_char),
226: fnd_api.g_miss_char, 'Y', p_txn_ext_attrib_vals_rec.preserve_detail_flag)
227: INTO l_preserve_detail_flag
228: FROM sys.dual;
229:
230: -- defaulting the process_flag
231: IF nvl(p_txn_ext_attrib_vals_rec.attribute_value, fnd_api.g_miss_char) = fnd_api.g_miss_char
232: THEN

Line 1603: SELECT TRUNC(SYSDATE) INTO l_sysdate FROM dual ;

1599: x_source_table := NULL ;
1600: l_attribute_value_id := NULL ;
1601: l_loop_count := 0;
1602:
1603: SELECT TRUNC(SYSDATE) INTO l_sysdate FROM dual ;
1604:
1605: IF p_attrib_level = 'GLOBAL'
1606: THEN
1607: FOR get_global_attrib_rec IN get_global_attrib_cur(p_attrib_code)