653: l_delivery_assignment_id NUMBER;
654: l_par_delivery_assignment_id NUMBER;
655: l_lpn_id NUMBER;
656:
657: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
658: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
659:
660: CURSOR lpn_cur(p_delivery_id NUMBER) IS
661: SELECT wdd.lpn_id, wdd.organization_id
654: l_par_delivery_assignment_id NUMBER;
655: l_lpn_id NUMBER;
656:
657: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
658: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
659:
660: CURSOR lpn_cur(p_delivery_id NUMBER) IS
661: SELECT wdd.lpn_id, wdd.organization_id
662: FROM (SELECT delivery_detail_id