APPS.WSH_DEL_OI_CORE dependencies on SO_HEADERS_ALL

Line 16: FROM so_headers_all soh,

12: declare
13: cursor order_info is
14: SELECT soh.currency_code ,
15: soh.order_category
16: FROM so_headers_all soh,
17: so_picking_headers_all soph
18: WHERE soph.picking_header_id = X_picking_header_id
19: AND soh.header_id = soph.order_header_id;
20: begin

Line 1053: FROM so_headers_all h,

1049: BEGIN
1050: declare
1051: CURSOR multi_org_check is
1052: SELECT 'SHIP_DIFF_ORG'
1053: FROM so_headers_all h,
1054: so_picking_headers_all ph
1055: WHERE h.header_id = ph.order_header_id
1056: AND ph.picking_header_id = X_picking_header_id
1057: AND nvl(h.org_id,-99) <>