APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on WSH_NEW_DELIVERIES

Line 1223: wsh_new_deliveries wnd

1219: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1220: SELECT wdd.delivery_detail_id, wnd.confirm_date
1221: FROM wsh_delivery_details wdd,
1222: wsh_delivery_assignments wda,
1223: wsh_new_deliveries wnd
1224: WHERE wdd.delivery_detail_id = p_ddetail_id
1225: AND wda.delivery_detail_id = wdd.delivery_detail_id
1226: AND wnd.delivery_id = wda.delivery_id;
1227:

Line 1979: wsh_new_deliveries wnd

1975: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1976: SELECT wdd.delivery_detail_id, wnd.confirm_date
1977: FROM wsh_delivery_details wdd,
1978: wsh_delivery_assignments wda,
1979: wsh_new_deliveries wnd
1980: WHERE wdd.delivery_detail_id = p_ddetail_id
1981: AND wda.delivery_detail_id = wdd.delivery_detail_id
1982: AND wnd.delivery_id = wda.delivery_id;
1983:

Line 4516: wsh_new_deliveries wnd

4512: cursor c_confirmed_date(p_delivery_Detail_id Number) is
4513: select confirm_date
4514: FROM wsh_delivery_details wdd,
4515: wsh_delivery_assignments wda,
4516: wsh_new_deliveries wnd
4517: WHERE wdd.delivery_detail_id = (p_delivery_Detail_id)
4518: AND wda.delivery_detail_id = wdd.delivery_detail_id
4519: AND wnd.delivery_id = wda.delivery_id;
4520:

Line 4539: v_confirm_date wsh_new_deliveries.confirm_date%type;

4535: ln_inventory_item_id NUMBER;
4536: ln_item_exists NUMBER;
4537:
4538: v_ordered_Date oe_order_headers_all.ordered_date%type;
4539: v_confirm_date wsh_new_deliveries.confirm_date%type;
4540: v_excise_return_days Number;
4541: v_sales_return_days Number;
4542:
4543: CURSOR get_order_source_type(cp_source_document_type_id NUMBER) IS