APPS.WSH_UTIL_CORE dependencies on WSH_PICKING_RULES

Line 7182: v_SCRuleID wsh_picking_rules.ship_confirm_rule_id%TYPE;

7178: HISTORY : rlanka 03/01/2005 Created
7179: =======================================================================*/
7180: FUNCTION GetShipConfirmRule(p_picking_rule_id IN NUMBER) RETURN NUMBER IS
7181: --
7182: v_SCRuleID wsh_picking_rules.ship_confirm_rule_id%TYPE;
7183: l_debug_on BOOLEAN;
7184: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GetShipConfirmRule';
7185: --
7186: BEGIN

Line 7201: FROM wsh_picking_rules

7197: END IF;
7198: --
7199: SELECT ship_confirm_rule_id
7200: INTO v_SCRuleID
7201: FROM wsh_picking_rules
7202: WHERE picking_rule_id = p_picking_rule_id;
7203: --
7204: IF l_debug_on THEN
7205: WSH_DEBUG_SV.log(l_module_name, 'Ship Confirm Rule', v_SCRuleID);