APPS.WSH_PICK_LIST dependencies on WSH_PICK_GROUPING_RULES

Line 3855: from wsh_pick_grouping_rules wpgr

3851: AND NVL(is_sub_request, 'N') = 'Y';
3852:
3853: CURSOR c_is_psgr_del(p_psgr_id NUMBER) IS
3854: select NVL(wpgr.delivery_flag, 'N')
3855: from wsh_pick_grouping_rules wpgr
3856: where wpgr.pick_grouping_rule_id = p_psgr_id
3857: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3858: nvl(wpgr.end_date_active, trunc(sysdate)+1);
3859:

Line 3880: from wsh_pick_grouping_rules wpgr

3876: where wt.id = wsp.organization_id
3877: and (wsp.print_pick_slip_mode = 'I'
3878: OR exists
3879: (select '1'
3880: from wsh_pick_grouping_rules wpgr
3881: where wpgr.pick_grouping_rule_id = wsp.pick_grouping_rule_id
3882: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3883: nvl(wpgr.end_date_active, trunc(sysdate)+1)
3884: AND wpgr.delivery_flag = 'Y'))

Line 3894: from wsh_pick_grouping_rules wpgr

3890: where wsp.organization_id = p_org_id
3891: and (wsp.print_pick_slip_mode = 'I'
3892: OR exists
3893: (select '1'
3894: from wsh_pick_grouping_rules wpgr
3895: where wpgr.pick_grouping_rule_id = wsp.pick_grouping_rule_id
3896: and sysdate between trunc(nvl(wpgr.start_date_active, sysdate)) and
3897: nvl(wpgr.end_date_active, trunc(sysdate)+1)
3898: AND wpgr.delivery_flag = 'Y'));