APPS.WSH_INTERFACE_GRP dependencies on WSH_SHIP_CONFIRM_RULES

Line 119: FROM wsh_ship_confirm_rules wsc

115: wsc.ship_method_code,
116: wsc.effective_end_date,
117: wsc.stage_del_flag,
118: wsc.action_flag
119: FROM wsh_ship_confirm_rules wsc
120: WHERE ((p_rule_id IS NOT NULL AND wsc.ship_confirm_rule_id = p_rule_id)
121: OR (p_rule_name IS NOT NULL AND wsc.name = p_rule_name))
122: AND (sysdate between wsc.effective_start_date
123: and nvl(wsc.effective_end_date,sysdate));