APPS.WSH_PR_PICKING_SESSION dependencies on WSH_PARAMETERS

Line 202: FROM WSH_PARAMETERS

198:
199: -- cursor to determine print pick slip mode parameter
200: CURSOR ps_mode_param(x_org_id IN BINARY_INTEGER) IS
201: SELECT NVL(PRINT_PICK_SLIP_MODE, 'E')
202: FROM WSH_PARAMETERS
203: WHERE ORGANIZATION_ID = x_org_id;
204:
205: -- cursor to get line information
206: CURSOR get_line_info(x_line_id In BINARY_INTEGER) IS

Line 653: FROM WSH_PARAMETERS par,

649: AND NVL(END_DATE_ACTIVE, SYSDATE+1);
650:
651: CURSOR get_default_psr(x_rule_name IN VARCHAR2) IS
652: SELECT par.pick_slip_rule_id
653: FROM WSH_PARAMETERS par,
654: SO_PICKING_RULES rules
655: WHERE rules.picking_rule = x_rule_name
656: AND rules.warehouse_id = par.organization_id;
657:

Line 660: FROM WSH_PARAMETERS par,

656: AND rules.warehouse_id = par.organization_id;
657:
658: CURSOR get_default_rsr(x_rule_name IN VARCHAR2) IS
659: SELECT par.release_seq_rule_id
660: FROM WSH_PARAMETERS par,
661: SO_PICKING_RULES rules
662: WHERE rules.picking_rule = x_rule_name
663: AND rules.warehouse_id = par.organization_id;
664: