APPS.CSI_ORDER_FULFILL_PUB dependencies on DUAL

Line 1883: FROM sys.dual

1879: IF p_ato_line_id is not null THEN
1880: BEGIN
1881: SELECT 'Y'
1882: INTO l_sub_model_flag
1883: FROM sys.dual
1884: WHERE exists (
1885: SELECT 'X'
1886: FROM bom_cto_order_lines
1887: WHERE ato_line_id = p_ato_line_id

Line 4997: FROM sys.dual

4993:
4994: BEGIN
4995: BEGIN
4996: SELECT 'Y' INTO l_phantom
4997: FROM sys.dual
4998: WHERE EXISTS (
4999: SELECT '1' FROM wip_requirement_operations
5000: WHERE wip_entity_id = p_wip_entity_id
5001: AND inventory_item_id = p_option_item_id

Line 7169: FROM sys.dual;

7165: to_char(l_qty_ratio)||':'||
7166: p_order_line_rec.order_quantity_uom ||':'||
7167: p_order_line_rec.ordered_quantity --added for bug5096435
7168: INTO l_model_hierarchy
7169: FROM sys.dual;
7170:
7171: debug(' model hierarchy string: '||l_model_hierarchy);
7172:
7173: csi_t_utilities_pvt.cascade_child(

Line 9072: FROM sys.dual;

9068: to_char(l_qty_ratio)||':'||
9069: l_order_line_rec.order_quantity_uom ||':'||
9070: l_order_line_rec.ordered_quantity --added for bug5096435
9071: INTO l_model_hierarchy
9072: FROM sys.dual;
9073:
9074: csi_t_utilities_pvt.cascade_child(
9075: p_data_string => l_model_hierarchy,
9076: x_return_status => l_return_status );