APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_SHIPPING_PARAMETERS

Line 3646: from wsh_shipping_parameters

3642: if( nvl(l_report_set_id, -1) = -1) then
3643: BEGIN
3644: select delivery_report_set_id
3645: into l_report_set_id
3646: from wsh_shipping_parameters
3647: where organization_id = p_organization_id;
3648: EXCEPTION
3649: when no_data_found then
3650: BEGIN

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

Line 4115: from wsh_shipping_parameters

4111: if( nvl(l_report_set_id, -1) = -1) then
4112: BEGIN
4113: select delivery_report_set_id
4114: into l_report_set_id
4115: from wsh_shipping_parameters
4116: where organization_id = l_org_id;
4117: EXCEPTION
4118: when no_data_found then
4119: BEGIN