APPS.WSH_PICK_LIST dependencies on WSH_PICK_GROUPING_RULES

Line 3945: from wsh_pick_grouping_rules wpgr

3941: AND NVL(is_sub_request, 'N') = 'Y';
3942:
3943: CURSOR c_is_psgr_del(p_psgr_id NUMBER) IS
3944: select NVL(wpgr.delivery_flag, 'N')
3945: from wsh_pick_grouping_rules wpgr
3946: where wpgr.pick_grouping_rule_id = p_psgr_id
3947: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3948: nvl(wpgr.end_date_active, trunc(sysdate)+1);
3949:

Line 3970: from wsh_pick_grouping_rules wpgr

3966: where wt.id = wsp.organization_id
3967: and (wsp.print_pick_slip_mode = 'I'
3968: OR exists
3969: (select '1'
3970: from wsh_pick_grouping_rules wpgr
3971: where wpgr.pick_grouping_rule_id = wsp.pick_grouping_rule_id
3972: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3973: nvl(wpgr.end_date_active, trunc(sysdate)+1)
3974: AND wpgr.delivery_flag = 'Y'))

Line 3984: from wsh_pick_grouping_rules wpgr

3980: where wsp.organization_id = p_org_id
3981: and (wsp.print_pick_slip_mode = 'I'
3982: OR exists
3983: (select '1'
3984: from wsh_pick_grouping_rules wpgr
3985: where wpgr.pick_grouping_rule_id = wsp.pick_grouping_rule_id
3986: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3987: nvl(wpgr.end_date_active, trunc(sysdate)+1)
3988: AND wpgr.delivery_flag = 'Y'));