APPS.GMP_APS_DS_PULL dependencies on DUAL

Line 1638: ||' FROM dual';

1634: ||' :pto_um , '
1635: ||' NULL , '
1636: ||' NULL '
1637: ||' ) '
1638: ||' FROM dual';
1639: v_new_res_usage := -1;
1640: OPEN c_uom_conv FOR uom_conv_cursor USING
1641: product_line,
1642: v_orgn_id, --sowmya added.

Line 3282: FROM dual ;

3278:
3279: SELECT DECODE(porigination_type,1,NULL,porder_no) ,
3280: DECODE(porigination_type,1,porder_no,NULL)
3281: INTO t_order_number, t_wip_entity_name
3282: FROM dual ;
3283:
3284: statement_demands :=
3285: ' INSERT INTO msc_st_demands ( '
3286: ||' organization_id, inventory_item_id, sr_instance_id, '

Line 5595: INTO cur_time FROM sys.dual ;

5591:
5592: cur_time VARCHAR2(25) := NULL ;
5593: BEGIN
5594: SELECT to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
5595: INTO cur_time FROM sys.dual ;
5596:
5597: log_message(cur_time);
5598: EXCEPTION
5599: WHEN OTHERS THEN