APPS.INL_LANDEDCOST_PVT dependencies on DUAL

Line 299: FROM dual;

295: AND uom_code = p_from_uom_code
296: AND organization_id = p_organization_id
297: AND inventory_item_id = p_inventory_item_id)
298: INTO l_converted_price
299: FROM dual;
300:
301: l_debug_info := 'l_converted_price';
302: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
303: p_procedure_name=> l_program_name,

Line 2466: FROM dual

2462: UNION
2463: SELECT 1 SEQ_NUM,
2464: p_to_component_name COMPONENT_NAME,
2465: p_to_component_id COMPONENT_ID
2466: FROM dual
2467: ORDER BY seq_num;
2468:
2469: TYPE component_ListType IS TABLE OF component%ROWTYPE; --Bulk implem
2470: component_List component_ListType; --Bulk implem

Line 2785: -- FROM DUAL;

2781: ELSE
2782: --Bug#9660084
2783: -- SELECT DECODE(l_next_level_allocation,'N','Y','N')
2784: -- INTO l_lc_flag
2785: -- FROM DUAL;
2786: IF l_next_level_allocation = 'N' THEN
2787: l_lc_flag := 'Y';
2788: ELSE
2789: l_lc_flag := 'N';

Line 3885: -- SELECT DECODE(l_count1,0,'Y','N') INTO l_lc_flag FROM DUAL;

3881: WHERE from_parent_table_name = 'INL_SHIP_HEADERS'
3882: AND from_parent_table_id = dist_List(iDist).ship_header_id;
3883:
3884: --Bug#9660084
3885: -- SELECT DECODE(l_count1,0,'Y','N') INTO l_lc_flag FROM DUAL;
3886: IF l_count1 = 0 THEN
3887: l_lc_flag := 'Y';
3888: ELSE
3889: l_lc_flag := 'N';