APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICK_SEQUENCE_RULES

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

4842: --========================================================================
4843: -- PROCEDURE : Validate_Pick_Seq_Rule_Name
4844: --
4845: -- COMMENT : Validates Pick_Sequence_Rule_Id/Pick_Sequence_Rule_Name against table
4846: -- wsh_pick_sequence_rules. If both values are specified then only
4847: -- Pick_Sequence_Rule_Id is used
4848: --========================================================================
4849:
4850: PROCEDURE Validate_Pick_Seq_Rule_Name

Line 4857: FROM wsh_pick_sequence_rules

4853: x_return_status OUT NOCOPY VARCHAR2 ) IS
4854:
4855: CURSOR check_pick_sequence_rule_name IS
4856: SELECT pick_sequence_rule_id
4857: FROM wsh_pick_sequence_rules
4858: WHERE p_pick_sequence_rule_id IS NOT NULL
4859: AND pick_sequence_rule_id = p_pick_sequence_rule_id
4860: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4861: UNION ALL

Line 4863: FROM wsh_pick_sequence_rules

4859: AND pick_sequence_rule_id = p_pick_sequence_rule_id
4860: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4861: UNION ALL
4862: SELECT pick_sequence_rule_id
4863: FROM wsh_pick_sequence_rules
4864: WHERE p_pick_sequence_rule_id IS NULL
4865: AND name = p_pick_sequence_rule_name
4866: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1);
4867: