APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICK_GROUPING_RULES

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

4721: --========================================================================
4722: -- PROCEDURE : Validate_Pick_Group_Rule_Name
4723: --
4724: -- COMMENT : Validates Pick_Grouping_Rule_Id/Pick_Grouping_Rule_Name against table
4725: -- wsh_pick_grouping_rules. If both values are specified then only
4726: -- Pick_Grouping_Rule_Id is used
4727: --========================================================================
4728:
4729: PROCEDURE Validate_Pick_Group_Rule_Name

Line 4736: FROM wsh_pick_grouping_rules

4732: x_return_status OUT NOCOPY VARCHAR2 ) IS
4733:
4734: CURSOR check_pick_grouping_rule_name IS
4735: SELECT pick_grouping_rule_id
4736: FROM wsh_pick_grouping_rules
4737: WHERE p_pick_grouping_rule_id IS NOT NULL
4738: AND pick_grouping_rule_id = p_pick_grouping_rule_id
4739: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4740: UNION ALL

Line 4742: FROM wsh_pick_grouping_rules

4738: AND pick_grouping_rule_id = p_pick_grouping_rule_id
4739: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1)
4740: UNION ALL
4741: SELECT pick_grouping_rule_id
4742: FROM wsh_pick_grouping_rules
4743: WHERE p_pick_grouping_rule_id IS NULL
4744: AND name = p_pick_grouping_rule_name
4745: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND nvl(end_date_active,trunc(sysdate) + 1);
4746: