APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_SHIP_CONFIRM_RULES

Line 3956: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr

3952: AND ROWNUM = 1;
3953:
3954: CURSOR C_Ship_Confirm_Parameters IS
3955: SELECT wsp.ship_confirm_rule_id, wscr.ac_intransit_flag, wscr.ac_close_trip_flag, wscr.ac_defer_interface_flag
3956: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr
3957: WHERE wsp.organization_id = p_organization_id
3958: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
3959:
3960: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS