APPS.MST_SNAPSHOT_TASK_UTIL dependencies on WSH_NEW_DELIVERIES

Line 188: from wsh_new_Deliveries

184: lDelId Number ;
185: begin
186: select delivery_id
187: into lDelId
188: from wsh_new_Deliveries
189: where Delivery_id = ldeliveryId
190: AND planned_flag in ( 'F' ,'Y');
191:
192: return(lDelId);

Line 234: wsh_new_deliveries del

230: select decode(det.source_line_type_code, 'OSP','Y','N')
231: into l_osp_flag
232: from wsh_Delivery_details det,
233: wsh_delivery_assignments assg,
234: wsh_new_deliveries del
235: where del.delivery_id= ldelivery_id
236: AND del.delivery_id = assg.delivery_id
237: AND assg.delivery_detail_id = det.delivery_detail_id
238: AND rownum = 1;