APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICK_SEQUENCE_RULES

Line 4802: -- wsh_pick_sequence_rules. If both values are specified then only

4798: --========================================================================
4799: -- PROCEDURE : Validate_Pick_Seq_Rule_Name
4800: --
4801: -- COMMENT : Validates Pick_Sequence_Rule_Id/Pick_Sequence_Rule_Name against table
4802: -- wsh_pick_sequence_rules. If both values are specified then only
4803: -- Pick_Sequence_Rule_Id is used
4804: --========================================================================
4805:
4806: PROCEDURE Validate_Pick_Seq_Rule_Name

Line 4813: FROM wsh_pick_sequence_rules

4809: x_return_status OUT NOCOPY VARCHAR2 ) IS
4810:
4811: CURSOR check_pick_sequence_rule_name IS
4812: SELECT pick_sequence_rule_id
4813: FROM wsh_pick_sequence_rules
4814: WHERE p_pick_sequence_rule_id IS NOT NULL
4815: AND pick_sequence_rule_id = p_pick_sequence_rule_id
4816: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4817: UNION ALL

Line 4819: FROM wsh_pick_sequence_rules

4815: AND pick_sequence_rule_id = p_pick_sequence_rule_id
4816: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4817: UNION ALL
4818: SELECT pick_sequence_rule_id
4819: FROM wsh_pick_sequence_rules
4820: WHERE p_pick_sequence_rule_id IS NULL
4821: AND name = p_pick_sequence_rule_name
4822: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1);
4823: