APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICK_GROUPING_RULES

Line 4769: -- wsh_pick_grouping_rules. If both values are specified then only

4765: --========================================================================
4766: -- PROCEDURE : Validate_Pick_Group_Rule_Name
4767: --
4768: -- COMMENT : Validates Pick_Grouping_Rule_Id/Pick_Grouping_Rule_Name against table
4769: -- wsh_pick_grouping_rules. If both values are specified then only
4770: -- Pick_Grouping_Rule_Id is used
4771: --========================================================================
4772:
4773: PROCEDURE Validate_Pick_Group_Rule_Name

Line 4780: FROM wsh_pick_grouping_rules

4776: x_return_status OUT NOCOPY VARCHAR2 ) IS
4777:
4778: CURSOR check_pick_grouping_rule_name IS
4779: SELECT pick_grouping_rule_id
4780: FROM wsh_pick_grouping_rules
4781: WHERE p_pick_grouping_rule_id IS NOT NULL
4782: AND pick_grouping_rule_id = p_pick_grouping_rule_id
4783: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4784: UNION ALL

Line 4786: FROM wsh_pick_grouping_rules

4782: AND pick_grouping_rule_id = p_pick_grouping_rule_id
4783: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4784: UNION ALL
4785: SELECT pick_grouping_rule_id
4786: FROM wsh_pick_grouping_rules
4787: WHERE p_pick_grouping_rule_id IS NULL
4788: AND name = p_pick_grouping_rule_name
4789: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1);
4790: