APPS.INL_LANDEDCOST_PVT dependencies on DUAL

Line 259: FROM dual;

255: AND uom_code = p_from_uom_code
256: AND organization_id = p_organization_id
257: AND inventory_item_id = p_inventory_item_id)
258: INTO l_converted_price
259: FROM dual;
260:
261: l_debug_info := 'l_converted_price';
262: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
263: p_procedure_name => l_function_name,

Line 1552: FROM dual

1548: UNION
1549: SELECT 1 SEQ_NUM,
1550: p_to_component_name COMPONENT_NAME,
1551: p_to_component_id COMPONENT_ID
1552: FROM dual
1553: ORDER BY seq_num;
1554: rec_component component%ROWTYPE;
1555:
1556: CURSOR assoc IS

Line 1744: FROM DUAL;

1740: END IF;
1741: ELSE
1742: SELECT DECODE(l_next_level_allocation,'N','Y','N')
1743: INTO l_lc_flag
1744: FROM DUAL;
1745:
1746: Manage_Allocation (p_ship_header_id,
1747: p_le_currency_code,
1748: p_association_id,

Line 2358: SELECT DECODE(l_count,0,'Y','N') INTO l_lc_flag FROM DUAL;

2354: FROM INL_adj_associations_v
2355: WHERE from_parent_table_name = 'INL_SHIP_HEADERS'
2356: AND from_parent_table_id = rec_dist.ship_header_id;
2357:
2358: SELECT DECODE(l_count,0,'Y','N') INTO l_lc_flag FROM DUAL;
2359:
2360: l_debug_info := 'rec_dist.ship_line_id';
2361: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2362: p_procedure_name => l_api_name,