APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_SHIPPING_PARAMETERS

Line 3708: FROM wsh_shipping_parameters wsp,

3704: -- Bug 8250367
3705: CURSOR ship_confirm_parameters IS
3706: SELECT wsp.ship_confirm_rule_id, wscr.stage_del_flag,
3707: wscr.ac_intransit_flag, wscr.ac_close_trip_flag, wscr.ac_defer_interface_flag
3708: FROM wsh_shipping_parameters wsp,
3709: wsh_ship_confirm_rules wscr
3710: WHERE wsp.organization_id = p_organization_id
3711: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
3712:

Line 3726: from wsh_shipping_parameters

3722: if( nvl(l_report_set_id, -1) = -1) then
3723: BEGIN
3724: select delivery_report_set_id
3725: into l_report_set_id
3726: from wsh_shipping_parameters
3727: where organization_id = p_organization_id;
3728: EXCEPTION
3729: when no_data_found then
3730: BEGIN

Line 4116: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr

4112: AND ROWNUM = 1;
4113:
4114: CURSOR C_Ship_Confirm_Parameters IS
4115: SELECT wsp.ship_confirm_rule_id, wscr.ac_intransit_flag, wscr.ac_close_trip_flag, wscr.ac_defer_interface_flag
4116: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr
4117: WHERE wsp.organization_id = p_organization_id
4118: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
4119:
4120: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS

Line 4275: from wsh_shipping_parameters

4271: if( nvl(l_report_set_id, -1) = -1) then
4272: BEGIN
4273: select delivery_report_set_id
4274: into l_report_set_id
4275: from wsh_shipping_parameters
4276: where organization_id = l_org_id;
4277: EXCEPTION
4278: when no_data_found then
4279: BEGIN