APPS.WSH_UTIL_CORE dependencies on WSH_PICKING_RULES

Line 7218: v_SCRuleID wsh_picking_rules.ship_confirm_rule_id%TYPE;

7214: HISTORY : rlanka 03/01/2005 Created
7215: =======================================================================*/
7216: FUNCTION GetShipConfirmRule(p_picking_rule_id IN NUMBER) RETURN NUMBER IS
7217: --
7218: v_SCRuleID wsh_picking_rules.ship_confirm_rule_id%TYPE;
7219: l_debug_on BOOLEAN;
7220: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GetShipConfirmRule';
7221: --
7222: BEGIN

Line 7237: FROM wsh_picking_rules

7233: END IF;
7234: --
7235: SELECT ship_confirm_rule_id
7236: INTO v_SCRuleID
7237: FROM wsh_picking_rules
7238: WHERE picking_rule_id = p_picking_rule_id;
7239: --
7240: IF l_debug_on THEN
7241: WSH_DEBUG_SV.log(l_module_name, 'Ship Confirm Rule', v_SCRuleID);